Database.PostgreSQL.Simple

Writing queries

The Query type

Parameter substitution

Type inference

Substituting a single parameter

Representing a list of values

Modifying multiple rows at once

Extracting results

Handling null values

Type conversions

Types

data ConnectInfo

data Connection

data Query

data In a

data Binary a

data Only a

data h :. t

Exceptions

data SqlError

data FormatError

data QueryError

data ResultError

Connection management

connect

connectPostgreSQL

postgreSQLConnectionString

defaultConnectInfo

close

Queries that return results

query

query_

Queries that stream results

data FoldOptions

data FetchQuantity

defaultFoldOptions

fold

foldWithOptions

fold_

foldWithOptions_

forEach

forEach_

Statements that do not return results

execute

execute_

executeMany

Transaction handling

withTransaction

data TransactionMode

data IsolationLevel

data ReadWriteMode

defaultTransactionMode

defaultIsolationLevel

defaultReadWriteMode

withTransactionLevel

withTransactionMode

begin

beginLevel

beginMode

commit

rollback

Helper functions

formatMany

formatQuery