Re: How to list and describe tables in psql??? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to list and describe tables in psql???
Date
Msg-id 52C4C942.5030401@gmail.com
Whole thread Raw
In response to How to list and describe tables in psql???  (peterlen <peteralen@earthlink.net>)
List pgsql-general
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@gmail.com


pgsql-general by date:

Previous
From: peterlen
Date:
Subject: How to list and describe tables in psql???
Next
From: Tom Lane
Date:
Subject: Re: duplicate OID issue when using pg_upgrade to move from 8.4 to 9.2