Re: Looking for a "show create table " equivalent

Поиск
Список
Период
Сортировка
От Wes James
Тема Re: Looking for a "show create table " equivalent
Дата
Msg-id CAFjCMHvMyMaWsO9kK4SfVbDdMc5Wpc+uYaQi2Z_WRJtWmMdqVg@mail.gmail.com
обсуждение исходный текст
Ответ на Looking for a "show create table " equivalent  ("B.Rathmann" <B.Rathmann@ping.de>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Wes James
Дата:
Сообщение: Re: Looking for a "show create table " equivalent
Следующее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: [NOVICE] Compare rows