はてなブックマーク

Posted: 2014-05-25 @ 16:25:15 Tags: postgres json sql Comments: here. Yesterday, I discovered how you can enable jsonb in postgres/psycopg2. Today, I experimented around with how to query the data in json columns. There is documentation, but it wasn’t initially clear to me how the different operations worked. CREATE TABLE json_test ( id serial primary key, data jsonb ); INSERT INTO json_test (data