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 | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])