Re: Get DB Structure

From: Steven Klassen <sklassen(at)commandprompt(dot)com>
To: Hadi Saboohi <saboohi(at)parsmail(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Get DB Structure
Date: 2005-01-16 16:23:54
Message-ID: 20050116162354.GA22512@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

# 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ramon Orticio 2005-01-17 02:10:29 postgresql8 for windowsXP
Previous Message Hadi Saboohi 2005-01-16 07:35:43 Get DB Structure