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