Re: Array, bytea and large objects - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Array, bytea and large objects
Date
Msg-id puy6wl84ia.fsf@srv.protecting.net
Whole thread Raw
In response to Array, bytea and large objects  (David Wall <d.wall@computer.org>)
List pgsql-general
In article <4989E659.3000706@computer.org>,
David Wall <d.wall@computer.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.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Pet Peeves?
Next
From: Sam Mason
Date:
Subject: Re: running postgres