Interface PostgresConnection

Interface representing a PostgreSQL connection with methods for querying and executing statements. PostgresConnection

interface PostgresConnection {
    execute: (
        statement: string,
        params: PostgresV3ParameterValue[],
    ) => bigint;
    query: (
        statement: string,
        params: PostgresV3ParameterValue[],
    ) => PostgresV3RowSet;
}

Index

Properties

Properties

execute

execute: (statement: string, params: PostgresV3ParameterValue[]) => bigint

Executes a statement on the database with the specified parameters.

Type declaration

- (statement: string, params: PostgresV3ParameterValue[]): bigint
- Parameters
  - statement: string
    The SQL statement to execute.
  - params: PostgresV3ParameterValue[]
    The parameters for the SQL statement.
  Returns bigint
  The number of rows affected by the execution.

query

query: (
statement: string,
params: PostgresV3ParameterValue[],
) => PostgresV3RowSet

Queries the database with the specified statement and parameters.

Type declaration

- (statement: string, params: PostgresV3ParameterValue[]): PostgresV3RowSet
- Parameters
  - statement: string
    The SQL statement to execute.
  - params: PostgresV3ParameterValue[]
    The parameters for the SQL statement.
  Returns PostgresV3RowSet
  The result set of the query.