Postgres Pro
Downloads
Home   >   mailing lists

PG-9.0 - XML Data in a Column - Mailing list pgsql-novice

From Arvind Sharma
Subject PG-9.0 - XML Data in a Column
Date
Msg-id 1316728951.51526.YahooMailNeo@web110102.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: postgresql / osx lion  (Arvind Sharma <arvind321@yahoo.com>)
Responses Re: PG-9.0 - XML Data in a Column  (Arvind Sharma <arvind321@yahoo.com>)
Re: PG-9.0 - XML Data in a Column  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-novice
Tree view
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.

Thanks!
Arvind

pgsql-novice by date:

Previous
From: e-letter
Date:
Subject: Re: ERROR: invalid input syntax for integer:
Next
From: Hany ABOU-GHOURY
Date:
Subject: Fwd: [PERFORM] PG 9 adminstrations