Re: how to recall the initial definition (CREATE TABLE)

On 1/9/06, Sean Davis <sdavis2@mail.nih.gov> wrote:
>
>
>
> On 1/9/06 1:27 PM, "Joao Miguel Ferreira" <jmf@estg.ipvc.pt> wrote:
>
> > Hello all at PG,
> >
> > Let's say I forgot the "definition" of a table (.. the original CREATE
> > TABLE query)...
>
> Use pg_dump or use some program like PgAdminIII to give you the table
> definition.  There is no "DESCRIBE mytable" like in MySQL.
>
> Sean
>
>

or inside psql you can execute the \d command table to see the table
definition...

or even you can do in the shelll


psql -U postgres -d database_name -c "\d schema_name.table_name" > file

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)