Thursday, May 30, 2013

Re: view data tables?

thanks!!!! It worked pretty well!


On Sun, May 26, 2013 at 6:47 AM, Drew Ferguson <drew@afccommercial.co.uk> wrote:
On Sun, 26 May 2013 06:14:11 +0530
Kakar Arunachal Service <kakararunachalservice@gmail.com> wrote:

> Sad, i'm on windows! So, can u tell me how to view the tables that i
> created after syncdb django in pg admin3, there were so many tables. M
> sorry, m jst a begginer. I dont understand much.

So you are using Postgres and pgadmin3; below applies to all
databases

the tables you are interested in are

django_* tables for the admin site
auth_* tables for django user/group authentication
<your_app>_<model_name> tables for models you have defined

Tables created from your model classes in models.py are named using your
application name followed by the model name.
If your application is called "my_app" and you define a model "my_model"
then the table in the database will be

        my_app_my_model

unless you over-ride it

see also https://docs.djangoproject.com/en/1.5/ref/models/options/#table-names


>
>
> On Sun, May 26, 2013 at 5:51 AM, Drew Ferguson
> <drew@afccommercial.co.uk>wrote:
>
> > On Sun, 26 May 2013 05:23:08 +0530
> > Kakar Arunachal Service <kakararunachalservice@gmail.com> wrote:
> >
> > > Hi, how to view the tables in pg admin for postgresql database, or in
> > > workbench for mysql db.?? Like there's sqlite databse browser for
> > > sqlite3. Any other GUI maybe?
> > >
> >
> > Is this what you are looking for?
> >
> >
> > http://stackoverflow.com/questions/835069/which-sqlite-administration-console-do-you-recommend
> >
> > On my Linux system, sqliteman gets the billing
> >
> > "The best developer's and/or admin's GUI tool for Sqlite3 in the world"
> >
> > someone thinks it is good. I wouldn't know
> > --
> > Drew Ferguson
> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Django users" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> > an email to django-users+unsubscribe@googlegroups.com.
> > To post to this group, send email to django-users@googlegroups.com.
> > Visit this group at http://groups.google.com/group/django-users?hl=en.
> > For more options, visit https://groups.google.com/groups/opt_out.
> >
> >
> >
>



--
Drew Ferguson

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment