Database.HDBC.PostgreSQL.HStore

Read and write stuff in hstore columns.

Insert crap into table:

 let myStuff = [("test", "shmest"), ("spam", "eggs"), ("sausage", "salad")]
 withTransaction conn $ trans -> run trans ("INSERT INTO test_hstore (stuff) VALUES (" ++ hsQuery myStuff  ++ ");") (hsParams myStuff)

Parse hstore data:

 rows <- quickQuery conn "SELECT * FROM test_hstore;" []
 forM_ rows $ [pk, hstuff] -> print $ (fromSql pk :: Integer, hsParse hstuff)

Make a query

hsQuery :: [(String, String)] -> String

Generate a placeholder string.

hsParams :: [(String, String)] -> [SqlValue]

Generate a parameter list.

Parse results

hsParse :: SqlValue -> Map Text Text

Parse a SqlByteString with hstore data to a Map Text Text.

Parser internals

hstoreParser :: Parser (Map Text Text)

Parse hstore-formatted value.

kvPair :: Parser (Text, Text)

Parse one key-value pair.

doubleQuoted :: Parser Text

Grab a value, unquote, unslash.