Hello
psql <dbname> \dt employee Should do the trick "Ron de Jong" <[EMAIL PROTECTED]> wrote in 9qp2et$i7q$[EMAIL PROTECTED]:">news:9qp2et$i7q$[EMAIL PROTECTED]: > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
