How to list and describe tables in psql???

Поиск
Список
Период
Сортировка
От peterlen
Тема How to list and describe tables in psql???
Дата
Msg-id 1388627604458-5785006.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: How to list and describe tables in psql???  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: How to list and describe tables in psql???  (Ian Lawrence Barwick <barwick@gmail.com>)
Re: How to list and describe tables in psql???  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
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?

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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: question on IPC vs TCPIP
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to list and describe tables in psql???