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