From: | Felipe Santos <felipepts(at)gmail(dot)com> |
---|---|
To: | Shujie Shang <sshang(at)pivotal(dot)io> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Kavi <kaviraj125(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [SQL] [GENERAL] JSON TO POSTGRE TABLE |
Date: | 2015-03-30 11:09:36 |
Message-ID: | CAPYcRiXCLKvr-iO6YJ18KS57uDLJ9k=vTx9wt5MLaBtoYNuObA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Deven Phillips | 2015-03-30 11:27:01 | Muti-table join and roll-up aggregate data into nested JSON? |
Previous Message | Hector Vass | 2015-03-30 10:48:07 | Re: [SQL] Link Office Word form document with data from PostgreSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Veyron | 2015-03-30 13:01:21 | Re: [GENERAL] Link Office Word form document with data from PostgreSQL |
Previous Message | Hector Vass | 2015-03-30 10:48:07 | Re: [SQL] Link Office Word form document with data from PostgreSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Veyron | 2015-03-30 13:01:21 | Re: [GENERAL] Link Office Word form document with data from PostgreSQL |
Previous Message | Hector Vass | 2015-03-30 10:48:07 | Re: [SQL] Link Office Word form document with data from PostgreSQL |