Re: [SQL] [GENERAL] JSON TO POSTGRE TABLE

2015-03-30 Thread Shujie Shang
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? On Mon, Mar 30, 2015 at 6:11 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Mon,

Re: [NOVICE] [SQL] [GENERAL] JSON TO POSTGRE TABLE

2015-03-30 Thread Felipe Santos
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: