Re: converting tables to XML and back - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: converting tables to XML and back
Date
Msg-id 87ljgchcz0.fsf@hi-media-techno.com
Whole thread Raw
In response to converting tables to XML and back  (shulkae <shulkae@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Large tables, ORDER BY and sequence/index scans
Next
From: Steve White
Date:
Subject: access computed field of RECORD variable