From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!! |
Date: | 2001-10-23 18:25:33 |
Message-ID: | 20011023132533.D31292@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 news:3bd02277$1_4(at)Usenet(dot)com(dot)(dot)(dot)
> > Hello
> >
> > psql <dbname>
> >
> > \dt employee
> >
> > Should do the trick
> >
> >
> > "Ron de Jong" <radejong(at)planet(dot)nl> wrote in
> > news:9qp2et$i7q$1(at)reader05(dot)wxs(dot)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(at)postgresql(dot)org
--
Ross Reedstrom, Ph.D. reedstrm(at)rice(dot)edu
Executive Director phone: 713-348-6166
Gulf Coast Consortium for Bioinformatics fax: 713-348-6182
Rice University MS-39
Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-10-23 18:29:04 | Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER |
Previous Message | Tom Lane | 2001-10-23 18:16:59 | Re: [GENERAL] Using an SMP machine to make multiple indices on the same table |