Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group