Postgres Pro
Downloads
Home   >   mailing lists

Re: Looking for a "show create table " equivalent - Mailing list pgsql-sql

From Wes James
Subject Re: Looking for a "show create table " equivalent
Date
Msg-id CAFjCMHvMyMaWsO9kK4SfVbDdMc5Wpc+uYaQi2Z_WRJtWmMdqVg@mail.gmail.com
Whole thread Raw
In response to Looking for a "show create table " equivalent  ("B.Rathmann" <B.Rathmann@ping.de>)
List pgsql-sql
Tree view 
On Tue, Jul 12, 2011 at 2:33 AM, B.Rathmann <B.Rathmann@ping.de> wrote:
> Hello,
>
> I've been trying to find out how to find out which sql was run to create
> a certain table. As I need this in a program which may access the
> database remotely, using pg_dump --schema-only or psql is not an option
> (the system my program runs on may not even have those tools installed).


Look at this for logging:

http://www.depesz.com/index.php/2011/05/06/understanding-postgresql-conf-log/

-wes

pgsql-sql by date:

Previous
From: Wes James
Date:
Subject: Re: Looking for a "show create table " equivalent
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: [NOVICE] Compare rows