LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Can't View PostgreSQL Table Data (https://www.linuxquestions.org/questions/linux-server-73/cant-view-postgresql-table-data-849513/)

carlosinfl 12-10-2010 12:07 PM
Can't View PostgreSQL Table Data
 
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


All times are GMT -5. The time now is 01:48 PM.