On Sat, Oct 20, 2001 at 05:24:39PM +0200, Ron de Jong wrote: > Not even close! >
Oh? What's it missing? the \dt display in psql has all the information in your mythical table versionbelow, just organized a little differently, doesn't it? Particularly on the hackers list, if there's a feature you think is lacking on PostgreSQL, then _describe_ it (pun intended) Ross > <None> wrote in message 3bd02277$[EMAIL PROTECTED]">news:3bd02277$[EMAIL PROTECTED]... > > 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Ross Reedstrom, Ph.D. [EMAIL PROTECTED] Executive Director phone: 713-348-6166 Gulf Coast Consortium for Bioinformatics fax: 713-348-6182 Rice University MS-39 Houston, TX 77005 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly