which is better- storing data as array or json?

From: zach cruise <zachc1980(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: which is better- storing data as array or json?
Date: 2015-02-18 01:03:30
Message-ID: CAL8icXy-NBz36L6d3bSoajDNMn98+7qeHszX-WgDPiCJzPHerg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

for indexing, accessing, filtering and searching?

as simple array-
first name | last name | nicknames
tom | jerry | {cat}, {mouse}

as multi-dimensional array-
first name | last name | nicknames
tom | jerry | {cat, kat}, {mouse, mice}

as simple json-
first name | last name | nicknames
tom | jerry | {"public": "cat", "private": "mouse"}

as multi-nested json-
first name | last name | nicknames
tom | jerry | {"public": {"first": "cat", "second": "kat"},
"private": {"first": "mouse", "second": "mice"}}

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2015-02-18 01:40:44 Re: which is better- storing data as array or json?
Previous Message Tom Lane 2015-02-18 00:31:18 Re: Issue dumping schema using readonly user