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).
PostgreSQL Hstore – How to Remove All Values of a Key
hstorepostgresql-9.3
Related Question
- Postgres HStore – HStore vs. Multiple Tables with Inheritance: Do I Have a Good Use Case for HStore?
- PostgreSQL HSTORE – How to Remove a Key
- Postgresql – How to store thousands of properties related to a record in PostgreSQL
- Postgresql – Postgres hstore check if a key exists and does not match value
- PostgreSQL – Updating an hstore with Multiple New Columns
- PostgreSQL – hstore trgm Search on Fixed Key
Best Answer
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;