Export table/view in xml-format

From: Detlef Jockheck <detlef(at)jockheck(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Export table/view in xml-format
Date: 2003-03-09 10:37:07
Message-ID: 200303091037.h29Ab8W05503@krakatau.jockheck.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

is there a tool to export contents of a table or view in xml? I would like
something that:
--- cut ---
<xml-header>
bla and blub
</xml-header>
<tablename>
<row>
<column_a>data</column_a>
<column_b>data</column_b>.
...
</row>
<row>
<column_a>data</column_a>
<column_b>data</column_b>
...
</row>
</tablename>
<xml-footer>
some text
</xml-footer>
--- cut ---

ciao Detlef
--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef(at)jockheck(dot)de
# -------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tue S.Dissing 2003-03-09 11:56:39 Missing postmaster.pid and PG_VERSION
Previous Message Justin Clift 2003-03-09 04:54:50 Re: [GENERAL] division by zero