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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026