Re: how to recall the initial definition (CREATE TABLE) of a table ?

Why don't you use PGAdmin ?

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Joao Miguel
Ferreira
Sent: Monday, January 09, 2006 11:57 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] how to recall the initial definition (CREATE TABLE) of
a table ?

Hello all at PG,

Let's say I forgot the "definition" of a table (.. the original CREATE
TABLE query)...

how do I ask PG to tell me these definition's (int not null, text,
foreign key, etc) ??

"definition" is not the correct word for this, is it ? what's the
correct term ?

thx

jmf

PS: ok, maybe I should go back to my SQL books...



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org