Is there no "DESCRIBE ;" on PGSQL? help!!! Поиск
Список
Период
Сортировка
От Ron de Jong
Тема Is there no "DESCRIBE ;" on PGSQL? help!!!
Дата
Msg-id 9qp2et$i7q$1@reader05.wxs.nl
обсуждение исходный текст
Ответы Re: Is there no "DESCRIBE ;" on PGSQL? help!!!  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Is there no "DESCRIBE
;" on PGSQL? help!!!  (Joel Burton <joel@joelburton.com>)
Re: Is there no "DESCRIBE
;" on PGSQL? help!!!  (Roland Roberts <roland@astrofoto.org>)
Список pgsql-hackers
Дерево обсуждения
Any idea to get a human readable list with column descriptions like
type,size,key,default,null.
It would be nice if it would look simular to the mysql variant:

mysql> describe employee;
+-----------+----------+------+-----+---------+----------------+
| Field     | Type     | Null | Key | Default | Extra          |
+-----------+----------+------+-----+---------+----------------+
| Id        | int(11)  |      | PRI | NULL    | auto_increment |
| FirstName | char(30) |      | MUL |         |                |
| LastName  | char(30) |      |     |         |                |
| Infix     | char(10) | YES  |     | NULL    |                |
| Address1  | char(30) | YES  |     | NULL    |                |
| PostCode  | char(10) | YES  |     | NULL    |                |
| Town      | int(11)  | YES  |     | NULL    |                |
+-----------+----------+------+-----+---------+----------------+
 
Cheers, Ron.

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

Предыдущее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: pg_sorttemp files
Следующее
От: Gunnar Rønning
Дата:
Сообщение: Re: schema support, was Package support for Postgres