On 11/11/2018 3:23 AM, ARAVIND BALAN wrote:
I used the inspectdb command but it does not solve my problem I still cant view the contents in user defined tables in psql
Did the manage.py inspectdb command write models for each of the non-Django tables in the database?
If not - you need to study the docs and get that working. Once it has written models for you, you can include them in admin.py alongside your other Django models, start up the dev server and look at them at http://localhost:8000/admin. That will prove whether or not the user-defined tables are visible via the Django ORM. I am confident it will work.
Once you have that proof, you can more confidently debug your Django-psql interface.
Actually, I don't have a copy of your original email so I might not understand the relationship you want between psql and Django. But in any case you should be quickly able to view those tables in the Django Admin.
Good luck Mike
On 10 Nov 2018 4:17 a.m., "Mike Dewhirst" <[email protected] <mailto:[email protected]>> wrote:On 9/11/2018 11:04 PM, ARAVIND BALAN wrote:I linked psql with django and can access django defined tables but cant access the contents of tables which I defined shows relation does not exist error . But can see the name of the table in \l command all the schema is publicThat's probably because Django needs to know about those tables ie., the ORM needs models representing them. There is a manage.py command 'inspectdb' which should create Django models of your non-Django defined tables. python manage.py help inspectdb usage: manage.py inspectdb [-h] [--version] [-v {0,1,2,3}] [--settings SETTINGS] [--pythonpath PYTHONPATH] [--traceback] [--no-color] [--database DATABASE] [table [table ...]] Introspects the database tables in the given database and outputs a Django model module. positional arguments: table Selects what tables or views should be introspected. optional arguments: -h, --help show this help message and exit --version show program's version number and exit -v {0,1,2,3}, --verbosity {0,1,2,3} Verbosity level; 0=minimal output, 1=normal output, 2=verbose output, 3=very verbose output --settings SETTINGS The Python path to a settings module, e.g. "myproject.settings.main". If this isn't provided, the DJANGO_SETTINGS_MODULE environment variable will be used. --pythonpath PYTHONPATH A directory to add to the Python path, e.g. "/home/djangoprojects/myproject". --traceback Raise on CommandError exceptions --no-color Don't colorize the command output. --database DATABASE Nominates a database to introspect. Defaults to using the "default" database.
-- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a62a418c-ef4f-a11c-b2ba-b2f2c2abba47%40dewhirst.com.au. For more options, visit https://groups.google.com/d/optout.
