On Thu, Sep 22, 2011 at 6:02 PM, Arvind Sharma <arvind321@yahoo.com> wrote:
> Hi,
>
> Is there a way to extract the contents of a column which is nothing but a
> well defined XML blob of data, and to be able to traverse the XML Elements (
> XPath style) using any in-build functions ?
>
> Also, how would I store such a XML blob in a column ? Declare the column as
> 'VARCHAR(256)' or something else ?
>
> Would this require any special module to be loaded at the Server startup ?
> I am using the PG-9.0 Installer from the official site.
Have you tried the built-in XML datatype and related functions?
http://developer.postgresql.org/pgdocs/postgres/functions-xml.html
If so, you should clarify specifically what is not working (provide an example).
Josh