Postgres Pro
Downloads
Home   >   mailing lists

Is there no "DESCRIBE ;" on PGSQL? help!!! - Mailing list pgsql-hackers
From Ron de Jong
Subject Is there no "DESCRIBE ;" on PGSQL? help!!!
Date
Msg-id 9qp2et$i7q$1@reader05.wxs.nl
Whole thread Raw
Responses Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Re: Is there no "DESCRIBE
;" on PGSQL? help!!!
Re: Is there no "DESCRIBE
;" on PGSQL? help!!!
List pgsql-hackers
Tree view
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.

pgsql-hackers by date:

Previous
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: pg_sorttemp files
Next
From: Gunnar Rønning
Date:
Subject: Re: schema support, was Package support for Postgres