Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!

Hello

psql <dbname>

\dt employee

Should do the trick

"Ron de Jong" <radejong(at)planet(dot)nl> wrote in
news:9qp2et$i7q$1(at)reader05(dot)wxs(dot)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)&nbsp; | YES&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; |
>|NULL&nbsp;&nbsp;&nbsp;
>|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>|&nbsp;&nbsp;&nbsp ;
>|<BR>+-----------+----------+------+-----+---------+----------------+</FO
>|NT></FONT></DIV>
> <DIV><FONT face=Arial size=2><FONT face="Courier
> New"></FONT></FONT>&nbsp;</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