Thread: converting tables to XML and back
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
shulkae <shulkae@gmail.com> writes: > 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. What about using pg_dump and pg_restore for the cloning, or maybe a replication solution? I don't know about your other needs for XML backups, but I'd prefer pg_dump over them anytime. -- dim
On Mon, Jan 04, 2010 at 07:46:29AM -0800, shulkae wrote: > We have few tables which we would like to convert to XML and store it. Not sure if you've seen them, but Postgres provides a few built in functions that will help with simple tasks: http://www.postgresql.org/docs/current/static/functions-xml.html > 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. Not tried to do this, but the functions from above should help. > How do I again re-create tables from XML? xpath() is what I've used for this before. It's performance isn't amazing, but it's been enough for the things I've used it for. -- Sam http://samason.me.uk/
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