| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgres and xml |
| Date: | 2005-06-10 16:02:29 |
| Message-ID: | 200506101602.j5AG2TS04672@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hrishikesh Deshmukh wrote:
> Hi All,
>
> Is there a way that makes it possible to export sql query results as a xml file?
> I use postgres 7.4.7 on a debian system. Do i need any packages to
> export query results as a xml file if its possible?
No, we have discussed it but it seems there is no standard XML export
format for databases, so you have to use something to use the COPY
output into XML. Perhaps there is an CSV to XML conversion tool you can
use.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Siebert | 2005-06-10 16:06:02 | 8.0 Install issues |
| Previous Message | Hrishikesh Deshmukh | 2005-06-10 15:56:03 | postgres and xml |