Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!

Not even close!

<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)&nbsp; | YES&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; |
> >|NULL&nbsp;&nbsp;&nbsp;
> >|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> >|&nbsp;&nbsp;&nbsp ;
> >|<BR>+-----------+----------+------+-----+---------+----------------+</FO
> >|NT></FONT></DIV>
> > <DIV><FONT face=Arial size=2><FONT face="Courier
> > New"></FONT></FONT>&nbsp;</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