Postgres Pro
Downloads
Home   >   mailing lists

Re: create definiton - Mailing list pgsql-general

From Tom Lane
Subject Re: create definiton
Date
Msg-id 18774.1024323537@sss.pgh.pa.us
Whole thread Raw
In response to create definiton  (pintman@gmx.de (Marco))
Responses Re: create definiton  (terry@greatgulfhomes.com)
List pgsql-general
Tree view 
pintman@gmx.de (Marco) writes:
> is it possible to find out, which create-statement i have used to
> create a certain table? if so, how?

    pg_dump -s -t tablename dbname

will reconstruct the table schema for you.

            regards, tom lane

pgsql-general by date:

Previous
From: Tycho Fruru
Date:
Subject: Re: Postgres DB recompilation
Next
From: Robert Treat
Date:
Subject: Re: Clients for administration?