Re: [GENERAL] using hstore to store documents - Mailing list pgsql-general

From Tomas Vondra
Subject Re: [GENERAL] using hstore to store documents
Date
Msg-id ce972c9f-0410-6c3a-a972-376b295ae127@2ndquadrant.com
Whole thread Raw
In response to [GENERAL] using hstore to store documents  (Rita <rmorgan466@gmail.com>)
Responses Re: [GENERAL] using hstore to store documents  (Rita <rmorgan466@gmail.com>)
List pgsql-general
On 01/26/2017 09:08 AM, Rita wrote:
> Is it possible to use hstore to store xml document?
>
> I would like to have
>
> "status" => "<xml>..."::xml
>

Keys/values in hstore are simply text strings, so you can store anything
you want formatted as a string.

Not sure if that's what you're looking for though, you'll probably need
to explain what you're trying to achieve to get better answers.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Rita
Date:
Subject: [GENERAL] using hstore to store documents
Next
From: Rita
Date:
Subject: Re: [GENERAL] using hstore to store documents