This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
To: pgsql-hackers@postgresql.org From: David Eduardo Gomez Noguera <davidgn@servidor.unam.mx> Subject: Re: [HACKERS] Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!! Date: Tue, 23 Oct 2001 19:36:50 -0600 Reply. > 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) > agreed. besides, what he want can be obtained by making queries to the system tables. just have to look through them a bit. > Ross > > > <None> wrote in message news:3bd02277$1_4@Usenet.com... > > > Hello > > > > > > psql <dbname> > > > > > > \dt employee > > > > > > Should do the trick > > > > > > > > > "Ron de Jong" <radejong@planet.nl> wrote in > > > news:9qp2et$i7q$1@reader05.wxs.nl: > > > > > > > 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 majordomo@postgresql.org > ===