Re: Is there no "DESCRIBE ;" on PGSQL? help!!! - Mailing list pgsql-hackers
From David Eduardo Gomez Noguera
Subject Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Date
Msg-id 20011023193650.6fc5eab8.davidgn@servidor.unam.mx
Whole thread Raw
In response to Re: Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
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
> 



-- 
ICQ: 15605359 Bicho                                 =^..^=
First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi.
........Por que no pensaran los hombres como los animales? Pink Panther........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CREATE OR REPLACE VIEW/TRIGGER
Next
From: Bruce Momjian
Date:
Subject: Re: CREATE OR REPLACE VIEW/TRIGGER