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/