How do I delete/remove the value of a postgresql hstore column?

I've got a table named pages and a column named settings - I need to remove the read_only value (basically, set it to empty string or nil).

1 Answer 1


Something like this, pages is the table, setting is the column, and key is what you are setting to null.

update pages set settings = settings || '"key"=>null'::hstore;


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.