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
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
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?
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?