Information for how to connect to a database, to be passed to pgConnect.

A database connection with sane defaults: localhost:5432:postgres

An established connection to the PostgreSQL server. These objects are not thread-safe and must only be used for a single request at a time.

PGException is thrown upon encountering an ErrorResponse with severity of ERROR, FATAL, or PANIC. It holds the message of the error.

Message SQLState code. See http://www.postgresql.org/docs/current/static/errcodes-appendix.html.

The database information for this connection.

The type environment for this connection.

Connect to a PostgreSQL server.

Disconnect cleanly from the PostgreSQL server.

Possibly re-open a connection to a different database, either reusing the connection if the given database is already connected or closing it and opening a new one. Regardless, the input connection must not be used afterwards.

Describe a SQL statement/query. A statement description consists of 0 or more parameter descriptions (a PostgreSQL type) and zero or more result field descriptions (for queries) (consist of the name of the field, the type of the field, and a nullability indicator).

A simple query is one which requires sending only a single SimpleQuery message to the PostgreSQL server. The query is sent as a single string; you cannot bind parameters. Note that queries can return 0 results (an empty list).

A simple query which may contain multiple queries (separated by semi-colons) whose results are all ignored. This function can also be used for "SET" parameter queries if necessary, but it's safer better to use pgDBParams.

Prepare a statement, bind it, and execute it. If the given statement has already been prepared (and not yet closed) on this connection, it will be re-used.

Like pgPreparedQuery but requests results lazily in chunks of the given size. Does not use a named portal, so other requests may not intervene.

Close a previously prepared query (if necessary).

Begin a new transaction. If there is already a transaction in progress (created with pgBegin or pgTransaction) instead creates a savepoint.

Commit the most recent pgBegin.

Rollback to the most recent pgBegin.

Commit all active pgBegins.

Rollback all active pgBegins.

Wrap a computation in a pgBegin, pgCommit block, or pgRollback on exception.

Disconnect cleanly from the PostgreSQL server, but only if it's still connected.

Prepare, bind, execute, and close a single (unnamed) query, and return the number of rows affected, or Nothing if there are (ignored) result rows.

Prepare a single query and return its handle.

Close a previously prepared query.

Bind a prepared statement, and return the row description. After pgBind, you must either call pgFetch until it completes (returns (_, Just _)) or pgFinish before calling pgBind again on the same prepared statement.

Fetch some rows from an executed prepared statement, returning the next N result rows (if any) and number of affected rows when complete.

Retrieve a notifications, blocking if necessary.

Retrieve any pending notifications. Non-blocking.

Constructs a PGTlsMode to validate the server certificate with given root certificate (in PEM format)