INSERT INTO users VALUES('
    "_id" => "derick@localhost",
    "location" => "London, UK",
    "count_unique" => 13,
    "isAdmin" => true
');
Get value for a key:


SELECT *hdoc->isAdmin* FROM users;
Find users with unique count larger than 10:


SELECT hdoc->_id FROM users WHERE hdoc->count_unique > 10;
Does key exists?


SELECT *hdoc ? age* FROM users;
Match key/value pair


SELECT \* FROM users WHERE *hdoc @> '"location"=>"London, UK"' :: hstore*;