Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!
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.
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.
|int(11) | YES |
|NULL
|
|   ;
|<BR>+-----------+----------+------+-----+---------+----------------+</FO
|NT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Courier
New"></FONT></FONT> </DIV> <DIV><FONT face=Arial size=2><FONT
face="Courier New">Cheers,
Ron.<BR><BR></DIV></FONT></FONT></BODY></HTML>Attachment decoded: untitled-3.htm
------=_NextPart_000_00A9_01C158A1.1FB50320--
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
psql \d command.
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.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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@joelburton.com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant
Not even close!
<None> wrote in message news:3bd02277$1_4@Usenet.com...
Show quoted text
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.
|int(11) | YES |
|NULL
|
|   ;
|<BR>+-----------+----------+------+-----+---------+----------------+</FO
|NT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Courier
New"></FONT></FONT> </DIV> <DIV><FONT face=Arial size=2><FONT
face="Courier New">Cheers,
Ron.<BR><BR></DIV></FONT></FONT></BODY></HTML>Attachment decoded: untitled-3.htm
------=_NextPart_000_00A9_01C158A1.1FB50320--Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
On Sat, Oct 20, 2001 at 05:24:39PM +0200, Ron de Jong wrote:
Not even close!
Oh? What's it missing? the \dt display in psql has all the information
in your mythical table versionbelow, just organized a little differently,
doesn't it?
Particularly on the hackers list, if there's a feature you think is
lacking on PostgreSQL, then _describe_ it (pun intended)
Ross
<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.
|int(11) | YES |
|NULL
|
|   ;
|<BR>+-----------+----------+------+-----+---------+----------------+</FO
|NT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Courier
New"></FONT></FONT> </DIV> <DIV><FONT face=Arial size=2><FONT
face="Courier New">Cheers,
Ron.<BR><BR></DIV></FONT></FONT></BODY></HTML>Attachment decoded: untitled-3.htm
------=_NextPart_000_00A9_01C158A1.1FB50320--Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Ross Reedstrom, Ph.D. reedstrm@rice.edu
Executive Director phone: 713-348-6166
Gulf Coast Consortium for Bioinformatics fax: 713-348-6182
Rice University MS-39
Houston, TX 77005
"Ron" == Ron de Jong <radejong@planet.nl> writes:
Ron> Any idea to get a human readable list with column
Ron> descriptions like type,size,key,default,null.
Ron> It would be nice if it would look simular to the mysql
Ron> variant:
You'll need to write your own query to get it to look like mysql.
From psql, you can do
\d employee
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375
Reply.
On Sat, Oct 20, 2001 at 05:24:39PM +0200, Ron de Jong wrote:
Not even close!
Oh? What's it missing? the \dt display in psql has all the information
in your mythical table versionbelow, just organized a little differently,
doesn't it?Particularly on the hackers list, if there's a feature you think is
lacking on PostgreSQL, then _describe_ it (pun intended)
agreed.
besides, what he want can be obtained by making queries to the system tables.
just have to look through them a bit.
Ross
<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.
|int(11) | YES |
|NULL
|
|   ;
|<BR>+-----------+----------+------+-----+---------+----------------+</FO
|NT></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face="Courier
New"></FONT></FONT> </DIV> <DIV><FONT face=Arial size=2><FONT
face="Courier New">Cheers,
Ron.<BR><BR></DIV></FONT></FONT></BODY></HTML>Attachment decoded: untitled-3.htm
------=_NextPart_000_00A9_01C158A1.1FB50320--Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
ICQ: 15605359 Bicho
=^..^=
First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi.
........Por que no pensaran los hombres como los animales? Pink Panther........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き
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