Horton

Re: SHOW , DESCRIBE, oh what's it called...

Anthony E . Greene <agreene@pobox.com>

View thread View on postgr.es
From: "Anthony E. Greene" <agreene@pobox.com>
To: pgsql-novice@postgresql.org
Date: 2000-06-14T12:02:25Z
Lists: 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.