Re: converting tables to XML and back

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