Get DB Structure

От:

"Hadi Saboohi" <saboohi@parsmail.net>

Дата:

16 января 2005 г. в 07:37:17

How can I get the db structure of a database in the system.

I want to change the structure of the db and also it's data to xml.

Hadi Saboohi

Re: Get DB Structure

От:

Steven Klassen <sklassen@commandprompt.com>

Дата:

16 января 2005 г. в 16:24:08

# How can I get the db structure of a database in the system.
#
# I want to change the structure of the db and also it's data to xml.

pg_dump -s your_database > your_database.sql

-- 
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564