Can't View PostgreSQL Table Data

carlosinfl · 12-10-2010, 12:07 PM

For some reason I am unable to view my database tables for my Wiki & I can't understand what I am doing wrong or what I'm missing. I know for sure there's table data on my 'wiki' database but for some reason I don't know how to list it.

Code:

psql (8.4.5)
Type "help" for help.

wiki=# \dt
No relations found.
wiki=# \d
No relations found.

Am I doing something wrong as I know there's data in there. I believe I'm just not submitting the proper commands to the server. Thanks for any assistance.

Tinkster · 12-11-2010, 03:41 PM

The commands are fine.

I'll hazard a guess and say that you installed your wiki as the
postgres user, and while you created a wiki user the tables & data
you're seeking aren't part of his database.

Cheers,
Tink