| From: | "Andrew Snow" <andrew(at)modulus(dot)org> |
|---|---|
| To: | "Tony Grant" <tony(at)animaproductions(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | RE: XML question |
| Date: | 2001-06-06 00:17:18 |
| Message-ID: | JEEGIJPOJIGGIIHGKOKOKEHFDFAA.andrew@modulus.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If you're asking how to get XML data into PostgreSQL, for perl users:
Matt Sergeant's DBIx::XML_RDB module looks handy. (I think it just got
added to the FreeBSD ports collection too).
http://www.xml.com/pub/a/2000/12/13/perlxmldb.html
Or use any XML parser module (XML::Simple!) and pump the data into
PostgreSQL using Pg or DBD.
Or roll your own parser, this doesn't take long in perl!
(I have successfully used the latter two methods)
- Andrew
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tony Grant
> Sent: Wednesday, 6 June 2001 12:49 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] XML question
>
>
> hello,
>
> Just a couple of questions:
>
> - what is the _most popular_ way of storing XML data in posgresql?
>
> - what is the _best_ way of stocking XML data in postgresql?
>
> Quick and nasty opinion poll...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Pilosov | 2001-06-06 00:23:49 | Re: optimizer hints? |
| Previous Message | Thalis A. Kalfigopoulos | 2001-06-06 00:15:09 | Re: outer joins take forever |