Postgres Pro
Downloads
Home   >   mailing lists

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

From Arvind Sharma
Subject Re: PG-9.0 - XML Data in a Column
Date
Msg-id 1317040539.39424.YahooMailNeo@web110113.mail.gq1.yahoo.com
Whole thread Raw
In response to PG-9.0 - XML Data in a Column  (Arvind Sharma <arvind321@yahoo.com>)
List pgsql-novice
Tree view
Anyone who can give me some pointers here ??

Some examples would definitely help.

Thanks!
Arvind

From: Arvind Sharma <arvind321@yahoo.com>
To: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Thursday, September 22, 2011 3:02 PM
Subject: PG-9.0 - XML Data in a Column

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: Hany ABOU-GHOURY
Date:
Subject: Re: Fwd: [PERFORM] PG 9 adminstrations
Next
From: Josh Kupershmidt
Date:
Subject: Re: PG-9.0 - XML Data in a Column