psql user defined models cant be acessed

[ARAVIND BALAN]

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 public

[Mike Dewhirst]

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

Post by ARAVIND BALAN
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 public

That'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.
  table                 Selects what tables or views should be
introspected.
  -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.