- Table of Contents
- pg_connect -- open a connection to the server
- pg_dbinfo -- returns data about the connection
- pg_disconnect -- close a connection to the server
- pg_conndefaults -- get connection options and their defaults
- pg_exec -- send a command to the server
- pg_exec_prepared -- send a request to execute a prepared SQL statement to the server
- pg_result -- get information about a command result
- pg_select -- loop over the result of a query
- pg_execute -- send a query and optionally loop over the results
- pg_listen -- set or change a callback for asynchronous notification messages
- pg_on_connection_loss -- set or change a callback for unexpected connection loss
- pg_sendquery -- send a query string to the backend connection without waiting for a result
- pg_sendquery_prepared -- send a request to execute a prepared statement to the backend connection, without waiting for a result
- pg_getresult -- process asychronous results
- pg_isbusy -- see if a query is busy
- pg_blocking -- see or set whether or not a connection is set to blocking or nonblocking
- pg_cancelrequest -- request that PostgreSQL abandon processing of the current command
- pg_null_value_string -- define a value to be returned for NULL fields distinct from the default value of an empty string.
- pg_quote -- escapes a string for inclusion into SQL statements
- pg_escape_string -- escapes a string for inclusion into SQL statements. This is the same as pg_quote. It was added for consistency.
- pg_escape_bytea -- escapes a binary string for inclusion into SQL statements.
- pg_unescape_bytea -- unescapes a binary string.
- pg_lo_creat -- create a large object
- pg_lo_open -- open a large object
- pg_lo_close -- close a large object
- pg_lo_read -- read from a large object
- pg_lo_write -- write to a large object
- pg_lo_lseek -- seek to a position of a large object
- pg_lo_tell -- return the current seek position of a large object
- pg_lo_truncate -- Truncate a large object to a given length
- pg_lo_unlink -- delete a large object
- pg_lo_import -- import a large object from a file
- pg_lo_export -- export a large object to a file
- pg_sqlite -- implements a bridge between PostgreSQL and Sqlite3 using the Pgtcl and sqlite3 packages.
- pg_copy_complete -- Completes a COPY FROM stdin operation
- PgGetConnectionId -- Provides access to the underlying libpq SQL connection handle.