Обсуждение: How to do this in pgsql?
Hi, I need to*Describe the table structure. Tried Desc <tab-name> as in oracle. But it failed. *Create an user-defined typein pgsql. can anybody help me pleez? thanks, Larry. __________________________________________________________________ Get your own free England E-mail address at http://www.england.com
Run 'perldoc DBI' and 'perldoc DBD::Pg' to read the fine manuals to see how to do this under DBI. I'm sure Postgress has some fine manuals, too. Describe is a SQL*Plus command, not a SQL command. -- Mac :}) ** I may forward private database questions to the DBI mail lists. ** ----- Original Message ----- From: "Larry ganga giri" <linuxfan@england.com> To: <pgsql-sql-owner+M349@hub.org> Cc: <pgsql-sql@postgresql.org> Sent: Wednesday, April 19, 2000 9:07 PM Subject: How to do this in pgsql? > I need to > *Describe the table structure. > Tried Desc <tab-name> as in oracle. > But it failed. > *Create an user-defined type in pgsql. > > can anybody help me pleez?
Hi Larry,
I'm something of a newbie to PostgreSQL myself, but I just happened to be
reading the section in Bruce Momjian's book that discusses how to display a
table's structure in psql. The command is "\d <table_name>".
The user-defined types will be in chapter 16, which is, as yet, unwritten.
But the Programmer's Guide seems to discuss this topic.
If you haven't looked at Momjian's book yet, I highly recommend you download
a copy.
http://www.postgresql.org/docs/awbook.html
Good luck,
-=michael=-
-----Original Message-----
From: Larry ganga giri [mailto:linuxfan@england.com]
Sent: Wednesday, April 19, 2000 9:08 PM
To: pgsql-sql-owner+M349@hub.org
Cc: pgsql-sql@postgresql.org
Subject: How to do this in pgsql?
Hi,
I need to*Describe the table structure. Tried Desc <tab-name> as in oracle. But it failed.*Create an user-defined
typein pgsql.
can anybody help me pleez?
thanks,
Larry.
__________________________________________________________________
Get your own free England E-mail address at http://www.england.com