Re: Is there no "DESCRIBE ;" on PGSQL? help!!! Поиск
Список
Период
Сортировка
От None
Тема Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Дата
Msg-id 3bd02277$1_4@Usenet.com
обсуждение исходный текст
Ответ на Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ron de Jong" <radejong@planet.nl>)
Список pgsql-hackers
Дерево обсуждения 
Hello


psql <dbname>

\dt employee

Should do the trick





"Ron de Jong" <radejong@planet.nl> wrote in
news:9qp2et$i7q$1@reader05.wxs.nl: 

> 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.
> 
> 
> 
>|int(11)  | YES       |
>|NULL    
>|            
>|    ; 
>|<BR>+-----------+----------+------+-----+---------+----------------+</FO
>|NT></FONT></DIV> 
> <DIV><FONT face=Arial size=2><FONT face="Courier
> New"></FONT></FONT> </DIV> <DIV><FONT face=Arial size=2><FONT
> face="Courier New">Cheers, 
> Ron.<BR><BR></DIV></FONT></FONT></BODY></HTML> 
> 
> Attachment decoded: untitled-3.htm
> ------=_NextPart_000_00A9_01C158A1.1FB50320--

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------   ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------                       http://www.usenet.com

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

Предыдущее
От: "Ron de Jong"
Дата:
Сообщение: Typhoon-Web-DataBase-Administrator-1.3.0 with PostgreSQL support released!!!
Следующее
От: "Ron de Jong"
Дата:
Сообщение: Re: Is there no "DESCRIBE ;" on PGSQL? help!!!