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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
