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: http://stackoverflow.com/questions/17807030/how-to-crea

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 wrote: > > > On Mon, Mar 30, 2015 at 6:54 PM