Home > mailing lists

Re: [NOVICE] [SQL] JSON TO POSTGRE TABLE - Mailing list pgsql-general

From	Felipe Santos
Subject	Re: [NOVICE] [SQL] JSON TO POSTGRE TABLE
Date	March 30, 2015 14:09:45
Msg-id	CAPYcRiXCLKvr-iO6YJ18KS57uDLJ9k=vTx9wt5MLaBtoYNuObA@mail.gmail.com Whole thread Raw
In response to	Re: [SQL] JSON TO POSTGRE TABLE (Shujie Shang <sshang@pivotal.io>)
List	pgsql-general

Tree view

Hi,
I want to ask a question about json index.
Can I make a index on a field of a json column?
e.g, for table 'json_tab' you given, can I run something like "create index 'json_index' on json_tab::key"?

Yes.

Here it is an example: http://stackoverflow.com/questions/17807030/how-to-create-index-on-json-field-in-postgres-9-3

Also, in 9.4 we got JSONB data type, which may enhance JSON fields performance.

pgsql-general by date:

From: Hector Vass
Date: 30 March 2015, 13:48:19
Subject: Re: [SQL] Link Office Word form document with data from PostgreSQL

From: Deven Phillips
Date: 30 March 2015, 14:27:09
Subject: Muti-table join and roll-up aggregate data into nested JSON?

Re: [NOVICE] [SQL] JSON TO POSTGRE TABLE - Mailing list pgsql-general

Previous

Next