Re: using hstore to store documents

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Rita <rmorgan466(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: using hstore to store documents
Date: 2017-01-26 08:58:18
Message-ID: ce972c9f-0410-6c3a-a972-376b295ae127@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rita 2017-01-26 12:37:29 Re: using hstore to store documents
Previous Message Rita 2017-01-26 08:08:09 using hstore to store documents