Re: [GENERAL] converting tables to XML and back

2010-01-05 Thread Scott Bailey
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

Re: [GENERAL] converting tables to XML and back

2010-01-05 Thread Sam Mason
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/functio

Re: [GENERAL] converting tables to XML and back

2010-01-05 Thread Dimitri Fontaine
shulkae 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?

[GENERAL] converting tables to XML and back

2010-01-04 Thread shulkae
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?