Re: [GENERAL] XML output & multiple SELECT queries

2008-06-15 Thread Peter Eisentraut
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 outp

[GENERAL] XML output & multiple SELECT queries

2008-06-14 Thread Peter Billen
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:

Re: [GENERAL] xml output

2006-03-22 Thread David Fetter
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

Re: [GENERAL] xml output

2006-03-22 Thread Jim C. Nasby
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 p

[GENERAL] xml output

2006-03-21 Thread Murali K. Maddali
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 appropri

Re: [GENERAL] xml output.

2006-03-20 Thread Murali K. Maddali
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 d

Re: [GENERAL] xml output.

2006-03-20 Thread Chris
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 yo

Re: [GENERAL] xml output.

2006-03-20 Thread Murali K. Maddali
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 t

Re: [GENERAL] xml output.

2006-03-20 Thread Chris
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, python

[GENERAL] xml output.

2006-03-20 Thread Murali K. Maddali
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 broadcast)-