Re: Need advise for database structure for non linear data.

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need advise for database structure for non linear data.
Date: 2011-01-03 11:36:41
Message-ID: ifscc1$cfa$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andre Lopes wrote on 03.01.2011 12:11:

> array(
> 'name' => 'Don',
> 'age' => '31'
> );
>
>
> array(
> 'name' => 'Peter',
> 'age' => '28',
> 'car' => 'ford',
> 'km' => '2000'
> );
>
> In a specific website search I will store only "name" and "age", and
> in other website I will store "name", "age", "car" and "km".
>
> I don't know If I explain weel my problem. My english is not very
> good.

That's exactly what the hstore data type supports:

http://www.postgresql.org/docs/current/static/hstore.html

Regards
Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Radosław Smogura 2011-01-03 11:46:34 Re: Need advise for database structure for non linear data.
Previous Message Thomas Schmidt 2011-01-03 11:26:45 Re: Need advise for database structure for non linear data.