On 01/01/2014 05:53 PM, peterlen wrote:
I am using PostgreSQL 9.1 and have boon looking for psql commands to list all tables in the current database as well as how to "describe" a given table. I have come across some info on the web (older mostly) that lists commands like \d, \dt, or \d+ <tablename> but I get results like "no relations found" or "column reltriggers does not exist". Not sure what is going on. Can someone enlighten me on the right commands to use?
Fresh from the docs: http://www.postgresql.org/docs/9.3/interactive/app-psql.html Search for: Meta-Commands There will be a copious amount of information available.
Thanks - Peter -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-list-and-describe-tables-in-psql-tp5785006.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
