[HACKERS] Is there no "DESCRIBE ;" on PGSQL? help!!!

Fri, 19 Oct 2001 05:32:50 -0700

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.

Reply via email to