Re: Is there no "DESCRIBE ;" on PGSQL? help!!! Поиск
Список
Период
Сортировка
От tweekie
Тема Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Дата
Msg-id 3bd92b40_1@Usenet.com
обсуждение исходный текст
Ответ на Is there no "DESCRIBE ;" on PGSQL? help!!!  ("Ron de Jong" <radejong@planet.nl>)
Список 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 по дате отправления:

Предыдущее
От: mlw
Дата:
Сообщение: Re: Ultimate DB Server
Следующее
От: "Sean Sell"
Дата:
Сообщение: Cross Database Links