Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: how to recall the initial definition (CREATE TABLE)
Date
Msg-id 20060109155601.GA9339@webserv.wug-glas.de
Whole thread Raw
In response to Re: how to recall the initial definition (CREATE TABLE)  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: how to recall the initial definition (CREATE TABLE)  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-novice
Tree view 
am  09.01.2006, um 10:38:06 -0500 mailte Jaime Casanova folgendes:
> > > Let's say I forgot the "definition" of a table (.. the original CREATE
> > > TABLE query)...

> or even you can do in the shelll
>
>
> psql -U postgres -d database_name -c "\d schema_name.table_name" > file

the result is unfortunately not a valid DDL...



Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Neil Saunders
Date:
Subject: Re: What does 'schema' mean ?
Next
From: "A. Kretschmer"
Date:
Subject: Re: What does 'schema' mean ?