Re: XML - Mailing list pgsql-novice

From Sean Davis
Subject Re: XML
Date
Msg-id c7550b977ce9217f8046d7790a8df077@mail.nih.gov
Whole thread Raw
In response to XML  (Sean Montague <couloir007@yahoo.com>)
List pgsql-novice
On Jul 18, 2005, at 6:19 PM, Sean Montague wrote:

> If I wanted to store the below XML in a text field, would I be able to
> insert additional attributes, and/or be able to substitute the id of
> the inner g tag when querying it from the database.  For example:
>
> From:
> <g id="myGtag>
>    <g id="myGtag2">
>    <\g>
> <\g>
>
> To:
> <g id="myGtag>
>    <g id="Button1a" onClick="click1();" >
>    <\g>
> <\g>

You might want to look at contrib/xml2 in the distribution (assuming
8.x).

Here are a couple of links:
http://www.throwingbeans.org/tech/postgresql_and_xml.html
http://www.throwingbeans.org/postgresql_and_xml_updated.html

Sean


pgsql-novice by date:

Previous
From: Sean Montague
Date:
Subject: XML
Next
From: "Michael Avila"
Date:
Subject: Utility to Convert MySQL to PostgreSQL