Knowledge-Database - Get DB Structure

Get DB Structure

From:	Hadi Saboohi
Subject:	Get DB Structure
Date:	Sun, 16 Jan 2005 11:05:43 +0330

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C4FBBB.82DB6910
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0000_01C4FBBB.82DB6910
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

charset=3Dus-ascii">

style=3D'text-align:left;direction:ltr;unicode-bidi:
embed'>style=3D'font-size:10.0pt;font-family:Arial'>How
can I get the db structure of a database in the =
system.

style=3D'text-align:left;direction:ltr;unicode-bidi:
embed'>style=3D'font-size:10.0pt;font-family:Arial'>I
want to change the structure of the db and also it's data to =
xml.

style=3D'text-align:left;direction:ltr;unicode-bidi:
embed'>style=3D'font-size:10.0pt;font-family:Arial'> nt>

style=3D'text-align:left;direction:ltr;unicode-bidi:
embed'>style=3D'font-size:10.0pt;font-family:Arial'>Hadi
Saboohistyle=3D'font-size:10.0pt;
font-family:Arial'>

------=_NextPart_000_0000_01C4FBBB.82DB6910--

From:	Steven Klassen
Subject:	Re: Get DB Structure
Date:	Sun, 16 Jan 2005 08:23:54 -0800

# 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly