Re: SHOW , DESCRIBE, oh what's it called... - Mailing list pgsql-novice

From Anthony E. Greene
Subject Re: SHOW , DESCRIBE, oh what's it called...
Date
Msg-id 3.0.5.32.20000614140225.00809c20@fmol.5sigcmd.army.mil
Whole thread Raw
In response to SHOW , DESCRIBE, oh what's it called...  ("Paul Fontenot" <paul@code-slinger.com>)
List pgsql-novice
At 16:22 2000-06-13 -0700, Paul Fontenot wrote:
>In MySQL you could issue a command:
>
>describe my_table_name;
>
>and it would come back with the columns, and their descriptions. What is the
>equivalent command in postgresql? I have looked everywhere and am probly
>just overlooking it by now.

pg_dump -s dbname > dbname.schema


 Tony
 --
 Anthony E. Greene <agreene@pobox.com>
 PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
 Linux: The choice of a GNU Generation.

pgsql-novice by date:

Previous
From: Patrick Coulombe
Date:
Subject: find the number of row for each tables
Next
From: "Karl F. Larsen"
Date:
Subject: Re: find the number of row for each tables