PostgreSQL: HSTORE

27/55

PostgreSQL

PostgreSQL: JSONB

• Stores a set of key/value pairs as strings
• Can be useful for semi structured data
• Useful for 'extra' data that isn't often queried


CREATE EXTENSION *hstore*;



CREATE TABLE users (hdoc *HSTORE*);



INSERT INTO users VALUES(*'*
    "_id" => "derick@localhost",
    "email" => "derick@localhost",
    "fullname" => "Derick Rethans",
    "slug" => "derick-rethans",
    "created_at" => *1452546141*,
    "timezone" => "Europe/London",
    "confirmed" => *true*,
    "confirmed_at" => 1452546148,
    "location" => "London, UK",
    "count" => 16,
    "count_unique" => 13,
    "isAdmin" => true
*'*);