Re: Reverse-engineering table creation statements

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Reverse-engineering table creation statements
Дата
Msg-id bddc86150909140827w68668679wa20ad73b8ee808b6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reverse-engineering table creation statements  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Ответы Re: Reverse-engineering table creation statements  (Ries van Twisk <pg@rvt.dds.nl>)
Список pgsql-general
Erk... I forgot to mention I don't wish to use command-line tools either.  I would like to submit something as a query in PHP and get back a result with the creation script in.  This is to modify some existing code which is currently only supporting MySQL.

Thom

2009/9/14 Chris Barnes <compuguruchrisbarnes@hotmail.com>
pg_dump --schema-only --schema=SCHEMA --table=TABLE
 
produces creation script.
 
Chris
 
http://www.postgresql.org/docs/8.0/interactive/backup.html
 

From: thombrown@gmail.com
Date: Mon, 14 Sep 2009 16:15:23 +0100
Subject: [GENERAL] Reverse-engineering table creation statements
To: pgsql-general@postgresql.org


Is there a simple way of generating a creation statement for a table without using psql or pgAdmin.  Basically I'd like to create what pgAdmin III shows in the SQL pane when you click on a table.  MySQL appears to have an equivalent which is SHOW CREATE table [tablename].

Thanks

Thom


Less clicking: Hotmail access on the new MSN homepage.

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Barnes
Дата:
Сообщение: Re: Reverse-engineering table creation statements
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Postgresql Hardware