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.









Any idea to get a human readable list with column 
descriptions liketype,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.
Fri, 19 Oct 2001 13:22:38 +0200
"Ron de Jong" <radejong@planet.nl>
Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
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)&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

19 Oct 2001 07:54:15 -0500
None <None@news.tht.net>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!

psql \d command.  

> 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.
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 19 Oct 2001 10:57:44 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
On Fri, 19 Oct 2001, Ron de Jong wrote:

> 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    |                |
> +-----------+----------+------+-----+---------+----------------+

Easily done -- look at the \d commands in psql or \h to get help
in psql. This is a FAQ -- STFW.

BTW, the -hackers list is for tricky questions requiring experienced
developer help, or for discussion among the gurus. Please post
general questions to pgsql-general or pgsql-novice and re-post
to pgsql-hackers only if you get no response w/in a week.

HTH,
-- 

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant


Fri, 19 Oct 2001 11:37:37 -0400 (EDT)
Joel Burton <joel@joelburton.com>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
Not even close!

<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)&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



Sat, 20 Oct 2001 17:24:39 +0200
"Ron de Jong" <radejong@planet.nl>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
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@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)&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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
Ross Reedstrom, Ph.D.                                 reedstrm@rice.edu
Executive Director                                  phone: 713-348-6166
Gulf Coast Consortium for Bioinformatics              fax: 713-348-6182
Rice University MS-39
Houston, TX 77005

Tue, 23 Oct 2001 13:25:33 -0500
"Ross J. Reedstrom" <reedstrm@rice.edu>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
>>>>> "Ron" == Ron de Jong <radejong@planet.nl> writes:

    Ron> Any idea to get a human readable list with column
    Ron> descriptions like type,size,key,default,null.

    Ron> It would be nice if it would look simular to the mysql
    Ron> variant:

You'll need to write your own query to get it to look like mysql.
>From psql, you can do

    \d employee

roland
-- 
		       PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375

23 Oct 2001 16:22:13 -0400
Roland Roberts <roland@astrofoto.org>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
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)&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
> > 
> > 
> > 
> > ---------------------------(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........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き


Tue, 23 Oct 2001 19:36:50 -0600
David Eduardo Gomez Noguera <davidgn@servidor.unam.mx>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!
Hello 

As the person who gave the original suggestion, I'd like to say that if you 
gave some more information, we may be able to help. What do you see when you 
do \dt ?

When I do it, I see more or less exactly what you report in mysql.


"Ron de Jong" <radejong@planet.nl> wrote in
news:9qs50m$pdf$1@reader07.wxs.nl: 

> Not even close!
> 
> <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.
>> >

> 
> 


 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com

26 Oct 2001 04:22:08 -0500
tweekie <None@news.tht.net>
Re: Is there no  "DESCRIBE <TABLE>;" on PGSQL?      help!!!