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

From: "Ron de Jong" <radejong(at)planet(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!
Date: 2001-10-19 11:22:38
Message-ID: 9qp2et$i7q$1@reader05.wxs.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jochem van Dieten 2001-10-19 11:26:27 Re: To Postgres Devs : Wouldn't changing the select limit
Previous Message Vince Vielhaber 2001-10-19 10:43:28 Re: Snaptshot appears fine to me ...