postgresql-simple- Mid-Level PostgreSQL client library

MaintainerLeon P Smith <>
Safe HaskellNone



The ToField typeclass, for rendering a parameter to a SQL query.



data Action Source

How to render an element when substituting it into a query.


Plain Builder

Render without escaping or quoting. Use for non-text types such as numbers, when you are certain that they will not introduce formatting vulnerabilities via use of characters such as spaces or "'".

Escape ByteString

Escape and enclose in quotes before substituting. Use for all text-like types, and anything else that may contain unsafe characters when rendered.

EscapeByteA ByteString

Escape binary data for use as a bytea literal. Include surrounding quotes. This is used by the Binary newtype wrapper.

Many [Action]

Concatenate a series of rendering actions.

toJSONField :: ToJSON a => a -> ActionSource

Convert a Haskell value to a JSON Value using toJSON and convert that to a field using toField.

This can be used as the default implementation for the toField method for Haskell types that have a JSON representation in PostgreSQL.

inQuotes :: Builder -> BuilderSource

Surround a string with single-quote characters: "'"

This function does not perform any other escaping.