📦 pgtcl

P

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