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

psql \d command.

> 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.
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026