Re: Is there no "DESCRIBE ;" on PGSQL? help!!! - Mailing list pgsql-hackers
From tweekie
Subject Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Date
Msg-id 3bd92b40_1@Usenet.com
Whole thread Raw
In response to Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ron de Jong" <radejong@planet.nl>)
List pgsql-hackers
Hello 

As the person who gave the original suggestion, I'd like to say that if you 
gave some more information, we may be able to help. What do you see when you 
do \dt ?

When I do it, I see more or less exactly what you report in mysql.


"Ron de Jong" <radejong@planet.nl> wrote in
news:9qs50m$pdf$1@reader07.wxs.nl: 

> Not even close!
> 
> <None> wrote in message news:3bd02277$1_4@Usenet.com...
>> Hello
>>
>>
>> psql <dbname>
>>
>> \dt employee
>>
>> Should do the trick
>>
>>
>>
>>
>>
>> "Ron de Jong" <radejong@planet.nl> wrote in
>> news:9qp2et$i7q$1@reader05.wxs.nl: 
>>
>> > 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.
>> >

> 
> 

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------   ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------                       http://www.usenet.com


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: Ultimate DB Server
Next
From: "Sean Sell"
Date:
Subject: Cross Database Links