Re: Is there no "DESCRIBE ;" on PGSQL? help!!! Поиск
Список
Период
Сортировка
От Ron de Jong
Тема Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Дата
Msg-id 9qs50m$pdf$1@reader07.wxs.nl
обсуждение исходный текст
Ответ на Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ron de Jong" <radejong@planet.nl>)
Ответы Re: Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-hackers
Not even close!

<None> wrote in message news:3bd02277$1_4@Usenet.com...
> 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 по дате отправления:

Предыдущее
От: None
Дата:
Сообщение: Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Следующее
От: Joel Burton
Дата:
Сообщение: Re: Catalogs design question