Postgres Pro
Downloads
Home   >   mailing lists

Re: Get DB Structure - Mailing list pgsql-novice

From Steven Klassen
Subject Re: Get DB Structure
Date
Msg-id 20050116162354.GA22512@commandprompt.com
Whole thread Raw
In response to Get DB Structure  ("Hadi Saboohi" <saboohi@parsmail.net>)
List pgsql-novice
Tree view 
# 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

pgsql-novice by date:

Previous
From: "Hadi Saboohi"
Date:
Subject: Get DB Structure
Next
From: Ramon Orticio
Date:
Subject: postgresql8 for windowsXP