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:38:31
Message-ID: CAFjCMHtw8Rv0Gq7Vhau3kCJfXbaQoi9AeE9iAqVJ-LJunvHdWQ@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

Maybe turning on some more verbose logging you can see what command is
doing that. I've poked around in the pg docs, but don't see it right
off.

-wes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wes James 2011-07-13 22:45:45 Re: Looking for a "show create table <name>" equivalent
Previous Message Guillaume Lelarge 2011-07-13 22:16:06 Re: Looking for a "show create table <name>" equivalent