store key name pattern search

From: "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: store key name pattern search
Date: 2017-04-04 15:41:42
Message-ID: BA47B3B7-F7A0-423F-86E0-0EE24D665791@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have the following case

select * from foo;
col1
---------------------------------------------------------------------------------
"show_id"=>"1", "group_id"=>"32", "group_name"=>"slb", "group_add_by"=>"557651"
"show_id"=>"2", "group_id"=>"33", "group_name"=>"slc", "item_add_by"=>"557652"
(2 rows)

Is there anyway I can do a pattern search by hstore key name something like

select * from foo where skeys(col1) like '%add_by%';

I looked on the doc but did not see anything , or did I miss it ?

Thanks

Armand

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom DalPozzo 2017-04-04 15:46:59 WAL being written during SELECT * query
Previous Message Armand Pirvu (home) 2017-04-04 15:34:51 Re: audit function and old.column