Describe structure.

\d tblpg

-----Message d'origine-----
De: anuj [mailto:Anuj@in-control.de]
Date: mardi 25 juillet 2000 11:03
�: pgsql-general@hub.org
Objet: [GENERAL] Describe structure.

Hi,
My table name is tblpg.
I want to see the table structure.
Like oracle have Describe <table name>.
What PG have ? or any command.
Thank in advance.
Anuj

pg=> \d
Database    = pg
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | postgres         | tblpg                            | table    |
 +------------------+----------------------------------+----------+

pg=> describe tblpg;
ERROR: parser: parse error at or near "describe"

On Tue, 25 Jul 2000, anuj wrote:

My table name is tblpg.
I want to see the table structure.
Like oracle have Describe <table name>.
What PG have ? or any command.
Thank in advance.
Anuj

pg=> \d
Database    = pg
+------------------+----------------------------------+----------+
|  Owner           |             Relation             |   Type   |
+------------------+----------------------------------+----------+
| postgres         | tblpg                            | table    |
+------------------+----------------------------------+----------+

It's all in the online help. The command you want is \d <table>.

Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
Yow! Is my fallout shelter termite proof?

While we're on the topic, can someone tell me where '\d *' went, and what to
use instead?
That particular command seems to have disappeared in PG7.

Thanks for any light-shedding...

-cw-

Wilkinson Charlie E writes:

While we're on the topic, can someone tell me where '\d *' went, and what to
use instead?
That particular command seems to have disappeared in PG7.

Hmm, that must have been me. What did it do? Describe all tables at once?

--
Peter Eisentraut Sernanders v�g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

On Tue, Jul 25, 2000 at 10:39:53PM +0200, Peter Eisentraut wrote:

Wilkinson Charlie E writes:

While we're on the topic, can someone tell me where '\d *' went, and what to
use instead?
That particular command seems to have disappeared in PG7.

Hmm, that must have been me. What did it do? Describe all tables at once?

I just tried it on a 6.5.0 install I've still got lying around: it first
dumps a \d output (i.e. all the tables, sequences, and indicies), then
describes all the tables, as you guessed.

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]

Wilkinson Charlie E writes:

While we're on the topic, can someone tell me where '\d *'

went, and what to

use instead?
That particular command seems to have disappeared in PG7.

Hmm, that must have been me. What did it do? Describe all
tables at once?

Hi Peter,
Yup, that's the one. Comes in handy for those of us who are
too lazy to describe them individually. :)

Basically what I need to do is print out a schema for all
tables in the database. \d * used to work quite well for
me. Is there any other option besides doing \d <table> for
each table (or creating a script to do it)?

-cw-

--
Charlie Wilkinson - TRIS Development Systems Administrator
IS:SD:CT:CC:TD
Phone: 202-283-3241
MSMail: Charlie E Wilkinson
SMTP: cwilkins@tris.irs.gov
Home: cwilkins@boinklabs.com
This message constructed from 90% post-consumer electrons.