Skip site navigation (1) Skip section navigation (2)

RE: How to do this in pgsql?

From: "Michael S(dot) Kelly" <michaelk(at)axian(dot)com>
To: "Larry ganga giri" <linuxfan(at)england(dot)com>, <pgsql-sql-owner+M349(at)hub(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: RE: How to do this in pgsql?
Date: 2000-04-20 23:52:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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.

Good luck,


-----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?


   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

In response to

pgsql-sql by date

Next:From: Jim JennisDate: 2000-04-20 23:58:52
Subject: VB (Virus Builder) Virus Posted
Previous:From: Michael S. KellyDate: 2000-04-20 23:26:49
Subject: RE: Recursive SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group