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

From: "Anthony E(dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: SHOW , DESCRIBE, oh what's it called...
Date: 2000-06-14 12:02:25
Message-ID: 3.0.5.32.20000614140225.00809c20@fmol.5sigcmd.army.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)pobox(dot)com>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Linux: The choice of a GNU Generation.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Karl F. Larsen 2000-06-14 12:23:30 Re: find the number of row for each tables
Previous Message Patrick Coulombe 2000-06-14 03:01:18 find the number of row for each tables