Postgresql-simple is a mid-level Haskell library for communicating with a PostgreSQL backend database. It is very simple to use and provides a type-safe API for reading/writing to a DB.
Running a simple query is as easy as:
{-# LANGUAGE OverloadedStrings #-}
import Database.PostgreSQL.Simple
...