which is better- storing data as array or json? - Mailing list pgsql-general

From zach cruise
Subject which is better- storing data as array or json?
Date
Msg-id CAL8icXy-NBz36L6d3bSoajDNMn98+7qeHszX-WgDPiCJzPHerg@mail.gmail.com
Whole thread Raw
Responses Re: which is better- storing data as array or json?
List 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"}}


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Issue dumping schema using readonly user
Next
From: David G Johnston
Date:
Subject: Re: which is better- storing data as array or json?