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
From: Larry ganga giri [mailto:linuxfan(at)england(dot)com]
Sent: Wednesday, April 19, 2000 9:08 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?
Get your own free England E-mail address at http://www.england.com
In response to
pgsql-sql by date
|Next:||From: Jim Jennis||Date: 2000-04-20 23:58:52|
|Subject: VB (Virus Builder) Virus Posted|
|Previous:||From: Michael S. Kelly||Date: 2000-04-20 23:26:49|
|Subject: RE: Recursive SQL |