Peter Billen wrote:
I would like to ask a question about outputting data as XML. Say I have two
tables:
team(integer id, text name);
player_of_team(integer id, integer team_id, text name); (team_id is FK to
team.id)
I would like to query both tables to get following example XML output:
Dear PostgreSQL users,
I would like to ask a question about outputting data as XML. Say I have two
tables:
team(integer id, text name);
player_of_team(integer id, integer team_id, text name); (team_id is FK to
team.id)
I would like to query both tables to get following example XML output:
team
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
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
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.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an
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 do this in PostgreSQL. I am looking
for a function or something like that. Does PostgreSQL support sqlxml.
Thank you,
Murali.
---(end of
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 do this in PostgreSQL. I am looking
for a function or something like that. Does PostgreSQL support sqlxml.
Don't think so. A small script (perl,
Can I use pl/pgsql or pl/tcl to write function to do that.
Murali.
Chris wrote:
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 do this in PostgreSQL. I am looking
for a function or something like
Murali K. Maddali wrote:
Can I use pl/pgsql or pl/tcl to write function to do that.
Can't see why not (I'm sure others will chime in if it's not possible or
not a good idea) but that's not going to help for a full database dump.
Doing a set of results it should work ok though. Depends what
I was trying to write out data from a table to an xml file, so that I
could export out this file to another external application from another
vendor. I got to export the data based on a predefined schema. I am able
to do this through .NET using c#, but I was wondering if there is way if
I can
10 matches
Mail list logo