Interface PostgresStoreOpts

Hierarchy

  • Options<Record<string, PostgresType<unknown>>>
    • PostgresStoreOpts

Properties

autocreateSchemaTable backoff connect_timeout connection database db debug fetch_types host hostname idle_timeout keep_alive max max_lifetime no_prepare onclose onnotice onparameter pass password path port prepare publications ssl target_session_attrs timeout transform types url user username

Properties

Optional autocreateSchemaTable

autocreateSchemaTable?: boolean

Should the schema table be automatically created (the v0 schema effectively). Defaults to true.

Optional backoff

backoff?: boolean | ((attemptNum: number) => number)

Optional connect_timeout

connect_timeout?: number

Connect timeout in seconds

Default

process.env['PGCONNECT_TIMEOUT']

Optional connection

connection?: Partial<ConnectionParameters>

Connection parameters

Optional database

database?: string

Name of database to connect to

Default

process.env['PGDATABASE'] || options.user

Optional db

db?: string

Name of database to connect to (an alias for database)

Optional debug

debug?: boolean | ((connection: number, query: string, parameters: any[], paramTypes: any[]) => void)

Is called with (connection; query; parameters)

Optional fetch_types

fetch_types?: boolean

Automatically fetches types on connect

Default

true

Optional host

host?: string

Inherit Doc

Optional hostname

hostname?: string

Postgres ip address or domain name (an alias for host)

Optional idle_timeout

idle_timeout?: number

Idle connection timeout in seconds

Default

process.env['PGIDLE_TIMEOUT']

Optional keep_alive

keep_alive?: null | number

Optional max

max?: number

Max number of connections

Default

10

Optional max_lifetime

max_lifetime?: null | number

Optional no_prepare

no_prepare?: boolean

Disable prepared mode

Deprecated

use "prepare" option instead

Optional onclose

onclose?: ((connId: number) => void)

Type declaration

    • (connId: number): void

    • Parameters

      • connId: number

      Returns void

Optional onnotice

onnotice?: ((notice: Notice) => void)

Type declaration

    • (notice: Notice): void

    • Called when a notice is received

      Default

      console.log

      Parameters

      • notice: Notice

      Returns void

Optional onparameter

onparameter?: ((key: string, value: any) => void)

Type declaration

    • (key: string, value: any): void

    • (key; value) when a server param change

      Parameters

      • key: string
      • value: any

      Returns void

Optional pass

pass?: string | (() => string | Promise<string>)

Password of database user (an alias for password)

Optional password

password?: string | (() => string | Promise<string>)

Password of database user

Default

process.env['PGPASSWORD']

Optional path

path?: string

Inherit Doc

Optional port

port?: number

Inherit Doc

Optional prepare

prepare?: boolean

Enables prepare mode.

Default

true

Optional publications

publications?: string

Publications to subscribe to (only relevant when calling sql.subscribe())

Default

'alltables'

Optional ssl

ssl?: boolean | object | "require" | "allow" | "prefer" | "verify-full"

How to deal with ssl (can be a tls.connect option object)

Default

false

Optional target_session_attrs

target_session_attrs?: "read-write" | "read-only" | "primary" | "standby" | "prefer-standby"

Use 'read-write' with multiple hosts to ensure only connecting to primary

Default

process.env['PGTARGETSESSIONATTRS']

Optional timeout

timeout?: number

Idle connection timeout in seconds

Deprecated

use "idle_timeout" option instead

Optional transform

transform?: { column?: ((column: string) => string) | { from?: ((column: string) => string); to?: ((column: string) => string) }; row?: ((row: Row) => any) | { from?: ((row: Row) => any) }; undefined?: any; value?: ((value: any) => any) | { from?: ((value: unknown, column: Column<string>) => any) } }

Transform hooks

Type declaration

  • Optional column?: ((column: string) => string) | { from?: ((column: string) => string); to?: ((column: string) => string) }

    Transforms incoming and outgoing column names

  • Optional row?: ((row: Row) => any) | { from?: ((row: Row) => any) }

    Transforms entire rows

  • Optional undefined?: any

    Transforms outcoming undefined values

  • Optional value?: ((value: any) => any) | { from?: ((value: unknown, column: Column<string>) => any) }

    Transforms incoming and outgoing row values

Optional types

types?: Record<string, PostgresType<unknown>>

Array of custom types; see more in the README

Optional url

url?: string

URL to reach the database on.

Optional user

user?: string

Username of database user

Default

process.env['PGUSERNAME'] || process.env['PGUSER'] || require('os').userInfo().username

Optional username

username?: string

Username of database user (an alias for user)

Settings

Member Visibility

Theme

Generated using TypeDoc