Skip site navigation (1) Skip section navigation (2)

PG-9.0 - XML Data in a Column

From: Arvind Sharma <arvind321(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: PG-9.0 - XML Data in a Column
Date: 2011-09-22 22:02:31
Message-ID: 1316728951.51526.YahooMailNeo@web110102.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Hany ABOU-GHOURYDate: 2011-09-23 01:17:37
Subject: Fwd: [PERFORM] PG 9 adminstrations
Previous:From: e-letterDate: 2011-09-22 21:27:22
Subject: Re: ERROR: invalid input syntax for integer:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group