Need SQL of create TABLE including INDEX and SEQUENCE

Поиск
Список
Период
Сортировка
От Francisco Leovey
Тема Need SQL of create TABLE including INDEX and SEQUENCE
Дата
Msg-id 342766.41897.qm@web39302.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Need SQL of create TABLE including INDEX and SEQUENCE  (Michael Glaesemann <grzm@seespotcode.net>)
Список pgsql-novice
Дерево обсуждения
Hello
 
For a new project where I am running 2 versions of Postgres (8.4 and 9.0) simultaneously on an Ubuntu server:
I need the syntax of an SQL statement in order to create tables and all index from one database to the other via a utility program I have in Perl.
I see PgAdmin shows on the lower pane all the SQL needed to create a table and all its index, but I do not know how to obtain that info.
It would be optimal if I can get all the info in a single query (the way pgdump does).
Also I need the SQL to create all the SEQUENCES.
 
Thank you
 
 

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

Предыдущее
От: Josh Kupershmidt
Дата:
Сообщение: Re: Valid role name (PostgreSQL 9.0.4)
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Need SQL of create TABLE including INDEX and SEQUENCE