Execute an SQL command (or commands). Pool performs this operation using one of its connections. Other than that, it behaves identic

Attempt to gracefully close all connections in the pool. Wait until all pool connections are released, close them and shut down the p

Run a query and return the first row. Pool performs this operation using one of its connections. Other than that, it behaves identic

Acquire a database connection from the pool. :param float timeout: A timeout for acquiring a Connection. :return: An instance of :cla

Run a query and return the results as a list of :class:`Record`. Pool performs this operation using one of its connections. Other than

Create a *prepared statement* for the specified query. :param str query: Text of the query to create a prepared statement for.

Create a :class:`~transaction.Transaction` object. Refer to `PostgreSQL documentation`_ on the meaning of transaction parameters.

Return a *cursor factory* for the specified query. :param args: Query arguments. :param int prefetch: The num

Return ``True`` if the connection is closed, ``False`` otherwise. :return bool: ``True`` if the connection is closed, ``False``

Return True if Connection is currently inside a transaction. :return bool: True if inside transaction, False otherwise. .. versionad

Release a database connection back to the pool. :param Connection connection: A :class:`~asyncpg.connection.Connection` object to

Execute an SQL *command* for each sequence of arguments in *args*. Pool performs this operation using one of its connections. Other than

Set an encoder/decoder pair for the specified data type. :param typename: Name of the data type the codec is for. :param

Add a record to pg_hba.conf.

Terminate all connections in the pool.

Start the cluster.

Return connection settings. :return: :class:`~asyncpg.ConnectionSettings`.

Copy the results of a query to a file or file-like object. Pool performs this operation using one of its connections. Other than tha

Copy data to the specified table. Pool performs this operation using one of its connections. Other than that, it behaves identically

Add a listener for Postgres notifications. :param str channel: Channel to listen on. :param callable callback: A callabl

Add a listener for Postgres log messages. It will be called when asyncronous NoticeResponse is received from the connection. Possibl

Return a description of relation attributes (columns). :return: A tuple of :class:`asyncpg.types.Attribute`. Example::

Return the PID of the Postgres server the connection is bound to.

Reload server configuration.

Exit the transaction or savepoint block and rollback changes.

Set a builtin codec for the specified scalar data type. This method has two uses. The first is to register a builtin codec for an ex

Return the maximum allowed number of connections in this pool. .. versionadded:: 0.25.0

Return the version of the connected PostgreSQL server. The returned value is a named tuple similar to that in ``sys.version_info``:

Remove a listening callback on the specified channel.

Reset *typename* codec to the default implementation. :param typename: Name of the data type the codec is for. :param sc

If the server didn't report "in_hot_standby" at startup, we must determine the state by checking "SELECT pg_catalog.pg_is_in_recovery()".

Copy a list of records to the specified table using binary COPY. Pool performs this operation using one of its connections. Other than

Run a query for each sequence of arguments in *args* and return the results as a list of :class:`Record`. Pool performs this operatio

r"""Skip over the next *n* rows. :param float timeout: Optional timeout value in seconds. :return: A number of rows actually skipped

Return the current number of idle connections in this pool. .. versionadded:: 0.25.0

Return ``True`` if the pool is closing or is closed. .. versionadded:: 0.28.0

Remove all records from pg_hba.conf.