Re: converting tables to XML and back

From: Scott Bailey <artacus(at)comcast(dot)net>
To: shulkae <shulkae(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: converting tables to XML and back
Date: 2010-01-05 16:44:07
Message-ID: 4B436C57.4050608@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2010-01-05 16:49:11 Re: how do I disable automatic start on mac os x?
Previous Message Milan Zamazal 2010-01-05 16:20:25 Re: Large tables, ORDER BY and sequence/index scans