Postgres Pro
Downloads
Home   >   mailing lists

Re: how to recall the initial definition (CREATE TABLE) of a table ? - Mailing list pgsql-novice

From
Subject Re: how to recall the initial definition (CREATE TABLE) of a table ?
Date
Msg-id 4538E1203665624F97A8494BCF2716E5012234F1@blrx2kmbgl102.blr.amer.dell.com
Whole thread Raw
In response to how to recall the initial definition (CREATE TABLE) of a table ?  (Joao Miguel Ferreira <jmf@estg.ipvc.pt>)
Responses Re: how to recall the initial definition (CREATE TABLE) of a table ?
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: how to recall the initial definition (CREATE TABLE)
Next
From: Brad Nicholson
Date:
Subject: Re: how to list all tables in a database