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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general