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

Поиск
Список
Период
Сортировка
От Ian Lawrence Barwick
Тема Re: How to list and describe tables in psql???
Дата
Msg-id CAB8KJ=iFqsEqLAoy_JyY+SMsk1DTP-DBOpC48ko-A=5dvx1y8Q@mail.gmail.com
обсуждение исходный текст
Ответ на How to list and describe tables in psql???  (peterlen <peteralen@earthlink.net>)
Ответы Re: How to list and describe tables in psql???
Список pgsql-general
014/1/2 peterlen <peteralen@earthlink.net>:
> 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?

Those are the correct commands, but it sounds like you're using an older
psql version against a newer server. Which psql version (psql -V) are you using?

Regards

Ian Barwick


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: duplicate OID issue when using pg_upgrade to move from 8.4 to 9.2
Следующее
От: peterlen
Дата:
Сообщение: Re: How to list and describe tables in psql???