Thread: Is there no "DESCRIBE ;" on PGSQL? help!!!

Is there no "DESCRIBE

;" on PGSQL? help!!!

From

"Ron de Jong"

Date:

19 October 2001, 11:20:35

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.

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

Bruce Momjian

Date:

19 October 2001, 14:22:43

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,
Pennsylvania19026
 

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

Joel Burton

Date:

19 October 2001, 16:26:23

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

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

None

Date:

23 October 2001, 13:21:08

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

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

"Ron de Jong"

Date:

23 October 2001, 13:21:09

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

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

"Ross J. Reedstrom"

Date:

23 October 2001, 23:24:02

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

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

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

Roland Roberts

Date:

24 October 2001, 01:35:59

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

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

David Eduardo Gomez Noguera

Date:

24 October 2001, 03:24:32

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........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き

Re: Is there no "DESCRIBE

;" on PGSQL? help!!!

From

tweekie

Date:

29 October 2001, 12:41:52

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

Есть вопросы? Напишите нам!

;" on PGSQL? help!!!', 'production')">Send

Соглашаюсь с условиями обработки персональных данных

I confirm that I have read and accepted PostgresPro’s Privacy Policy.

I agree to get Postgres Pro discount offers and other marketing communications.

✖

×

×

Everywhere Documentation Mailing list

List: all lists pgsql-general pgsql-hackers buildfarm-members pgadmin-hackers pgadmin-support pgsql-admin pgsql-advocacy pgsql-announce pgsql-benchmarks pgsql-bugs pgsql-chat pgsql-cluster-hackers pgsql-committers pgsql-cygwin pgsql-docs pgsql-hackers-pitr pgsql-hackers-win32 pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-patches pgsql-performance pgsql-php pgsql-pkg-debian pgsql-pkg-yum pgsql-ports pgsql-rrreviewers pgsql-ru-general pgsql-sql pgsql-students pgsql-testers pgsql-translators pgsql-www psycopg

Period anytime within last day within last week within last month within last 6 months within last year

Sort by date reverse date rank

By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy. I accept cookies