xml output

Started by Murali K. Maddaliabout 20 years ago3 messagesgeneral
Jump to latest
#1Murali K. Maddali
maddalimurali@gmail.com

Hello Guys,

I am trying to export the data out of the database directly to an xml
file. Is there a way that I could this in PostgreSQL.

Thank you,
Murali.

#2Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Murali K. Maddali (#1)
Re: xml output

On Mon, Mar 20, 2006 at 06:22:32PM -0600, Murali K. Maddali wrote:

Hello Guys,

I am trying to export the data out of the database directly to an xml
file. Is there a way that I could this in PostgreSQL.

Not automatically. You'll need to build the XML by hand, or by using
something like perl.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

#3David Fetter
david@fetter.org
In reply to: Murali K. Maddali (#1)
Re: xml output

On Mon, Mar 20, 2006 at 06:22:32PM -0600, Murali K. Maddali wrote:

Hello Guys,

I am trying to export the data out of the database directly to an
xml file. Is there a way that I could this in PostgreSQL.

You could use the libxml2 bindings in contrib/ and pipe that output to
a file.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!