Re: Array, bytea and large objects

From: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Array, bytea and large objects
Date: 2009-02-05 12:14:37
Message-ID: puy6wl84ia.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <4989E659(dot)3000706(at)computer(dot)org>,
David Wall <d(dot)wall(at)computer(dot)org> writes:

> If I have an "unlimited" number of name-value pairs that I'd like to
> get easy access to for flexible reports, could I store these in two
> arrays (one for name, the other for value) in a table so that if I had
> 10 name-value pairs or 200 name-value pairs, I could store these into
> a single row using arrays so I could retrieve all name-value pairs in
> a single SELECT from the db?

I would use the hstore contrib module for that.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-05 12:16:33 Re: running postgres
Previous Message Grzegorz Jaśkiewicz 2009-02-05 12:09:53 Re: Pet Peeves?