Re: How to list and describe tables in psql???

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(dot)klaver(at)gmail(dot)com