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