PostgreSQL中JSON数组中存在密钥

对于Postgres 9.4:

ds=# CREATE TABLE yourtable (movie jsonb);
CREATE TABLE
ds=# \d+ yourtable 
                      Table "public.yourtable"
 Column | Type  | Modifiers | Storage  | Stats target | Description 
--------+-------+-----------+----------+--------------+-------------
 movie  | jsonb |           | extended |              | 

ds=# INSERT INTO yourtable VALUES ('[{"title": "Pulp Fiction"}, {"tiitle": "Rambo"}]');
INSERT 0 1

ds=# SELECT * FROM yourtable yt,jsonb_array_elements(yt.movies) AS movie
WHERE movie ? 'tiitle';

SO有很多 good resources 与Postgres一起 documentation .