# posterize (0.13.3)

[![Build Status](https://travis-ci.org/talentdeficit/posterize.svg?branch=master)](https://travis-ci.org/talentdeficit/posterize)

an erlang wrapper for [postgrex](https://github.com/ericmj/postgrex)

documentation at [hexdocs](http://hexdocs.pm/posterize/)

## data representation

    postgres        erlang
    ----------      ------
    NULL            'null'
    bool            'true' | 'false'
    char            <<"é">>
    int             42
    float           42.0 | 'NaN' | 'infinity' | '-infinity'
    text            <<"hallo world">>
    bytea           <<42>>
    array           [1, 2, 3]
    composite type  {42, <<"title">>, <<"content">>}
    uuid            <<160,238,188,153,156,11,78,248,187,109,107,185,189,56,10,17>>
    hstore          #{<<"foo">> => <<"bar">>}
    date            {2016, 12, 14} | 'infinity' | '-infinity'
    timetz          {12261247241, 600000} | 'infinity' | '-infinity'
    timestamp       381783411081267571 | 'infinity' | '-infinity'
    timestamptz     381783411081267571 | 'infinity' | '-infinity'
    interval        #{ years => 1, months => 3, weeks => 3, days => 3, hours => 17, minutes => 4, seconds => 13, microseconds => 5 }
    json            <<"{}">> | <<"[]">> | <<"{\"foo\":\"bar\"}">> | ...
    jsonb           <<"{}">> | <<"[]">> | <<"{\"foo\":\"bar\"}">> | ...
    range           #{ lower => 1, upper => 3, bounds => '[)' }

## todo

* numerics, geo and all the other missing data types

## acknowledgments

this thing definitely wouldn't exist without [ericmj](https://github.com/ericmj) and [fishcakez](https://github.com/fishcakez). all credit to them