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

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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant