Re: create definiton

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pintman(at)gmx(dot)de (Marco)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: create definiton
Date: 2002-06-17 14:18:57
Message-ID: 18774.1024323537@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pintman(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serkan Bektaş 2002-06-17 15:17:21 Re: Clients for administration?
Previous Message Jan Wieck 2002-06-17 14:11:50 Re: shared memory