Re: Looking for a "show create table <name>" equivalent

From: Wes James <comptekki(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Looking for a "show create table <name>" equivalent
Date: 2011-07-13 22:45:45
Message-ID: CAFjCMHvMyMaWsO9kK4SfVbDdMc5Wpc+uYaQi2Z_WRJtWmMdqVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jul 12, 2011 at 2:33 AM, B.Rathmann <B(dot)Rathmann(at)ping(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2011-07-14 10:22:14 Re: Looking for a "show create table <name>" equivalent
Previous Message Wes James 2011-07-13 22:38:31 Re: Looking for a "show create table <name>" equivalent