| 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: | Whole Thread | Raw Message | 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 |