removing specific Key and value from Hstore in postgres i have a data which is in Hstore form so i want to select a specific key and value  from data and then delete them,  as i use this query it is find all rows which this key and value exist on it but i want those rows which is only involve this key and value not all

select * from topdog where tags @&gt; 'created_by=&gt;JOSM'


thanks
Seems that you should use the = (equality) operator instead of @&gt;(containment).

It will filter only the exact rows and you could use them in a delta statment.