Re: How to deal with field on the database that stores variable array's?

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to deal with field on the database that stores variable array's?
Date: 2011-01-01 20:52:28
Message-ID: AANLkTikX9CZKy6PB5UEYmZukztbLeUedjsY_xrb8K=Rp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1 January 2011 21:35, Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:

> Hi,
>
> I need to develop a database table that will aceept a variable array field.
> My doubt is how to deal with updates on the
> array field. How can I store the information of the array fields? There any
> examples on the Internet on how to deal with
> this subject?
>
> What I mean with variable array is:
>
>
> array(
> 'name' => 'Don',
> 'age' => '31'
> );
>
>
> array(
> 'name' => 'Peter',
> 'age' => '28',
> 'car' => 'ford',
> 'km' => '2000'
> );
>
>
> Best Regards,
>

Hi Andre,
check this out http://www.postgresql.org/docs/9.0/static/hstore.html

<http://www.postgresql.org/docs/9.0/static/hstore.html>regards
Szymon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-01-01 20:55:58 Re: How to deal with field on the database that stores variable array's?
Previous Message Andre Lopes 2011-01-01 20:35:57 How to deal with field on the database that stores variable array's?