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

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(at)planet(dot)nl> wrote in
news:9qs50m$pdf$1(at)reader07(dot)wxs(dot)nl:

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