Postgres Pro
Downloads
Home   >   mailing lists

Thread: Get DB Structure

Get DB Structure

From
"Hadi Saboohi"
Date:

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

From
Steven Klassen
Date:
# 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