I've been successfully using

    http://hackage.haskell.org/package/postgresql-simple

It's fine so far except it throws exceptions willy-nilly.  (I find
exceptions very un-Haskell but some people seem to like them).