Re: converting tables to XML and back - Mailing list pgsql-general

From Scott Bailey
Subject Re: converting tables to XML and back
Date
Msg-id 4B436C57.4050608@comcast.net
Whole thread Raw
In response to converting tables to XML and back  (shulkae <shulkae@gmail.com>)
List pgsql-general
shulkae wrote:
> We have few tables which we would like to convert to XML and store it.
>
> Another requirement is to convert the stored XML file back to the
> original tables.  This helps us to clone a system. I was thinking to
> use Perl XML Simple module to generate XML files.
>
> How do I again re-create tables from XML?
>
> thanks
> shul

Check out
http://developer.postgresql.org/index.php/XML_Support#Mapping_XML_Documents_to_SQL_Databases

Specifically the link to DBIx-XML-DataLoader


pgsql-general by date:

Previous
From: Milan Zamazal
Date:
Subject: Re: Large tables, ORDER BY and sequence/index scans
Next
From: Scott Ribe
Date:
Subject: Re: how do I disable automatic start on mac os x?