Postgres Pro
Downloads
Home   >   mailing lists

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

From Joao Miguel Ferreira
Subject how to recall the initial definition (CREATE TABLE) of a table ?
Date
Msg-id 1136831249.2460.26.camel@sandoval
Whole thread Raw
Responses Re: how to recall the initial definition (CREATE TABLE) of a table ?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: how to recall the initial definition (CREATE TABLE)  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view 
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...

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Triggers and speed - 7.4.5 / 8.0.3
Next
From: "A. Kretschmer"
Date:
Subject: Re: how to recall the initial definition (CREATE TABLE) of a table ?