RE: How to do this in pgsql?

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(at)england(dot)com]
Sent: Wednesday, April 19, 2000 9:08 PM
To: pgsql-sql-owner+M349(at)hub(dot)org
Cc: pgsql-sql(at)postgresql(dot)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 type in pgsql.

can anybody help me pleez?

thanks,
Larry.

__________________________________________________________________
Get your own free England E-mail address at http://www.england.com