| From: | <Amit_Wadhwa(at)Dell(dot)com> |
|---|---|
| To: | <jmf(at)estg(dot)ipvc(dot)pt>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: how to recall the initial definition (CREATE TABLE) of a table ? |
| Date: | 2006-01-09 13:58:54 |
| Message-ID: | 4538E1203665624F97A8494BCF2716E5012234F1@blrx2kmbgl102.blr.amer.dell.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Why don't you use PGAdmin ?
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Joao Miguel
Ferreira
Sent: Monday, January 09, 2006 11:57 PM
To: pgsql-novice(at)postgresql(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2006-01-09 14:08:15 | Re: how to recall the initial definition (CREATE TABLE) of a table ? |
| Previous Message | Sean Davis | 2006-01-09 13:13:08 | Re: Triggers and speed - 7.4.5 / 8.0.3 |