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 CAFjCMHtw8Rv0Gq7Vhau3kCJfXbaQoi9AeE9iAqVJ-LJunvHdWQ@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


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

pgsql-sql by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Looking for a "show create table " equivalent
Next
From: Wes James
Date:
Subject: Re: Looking for a "show create table " equivalent