September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.0 / 6.5 / 6.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

pg_conndefaults

Name

pg_conndefaults — obtain information about default connection parameters
pg_conndefaults

Inputs

None.

Outputs

option list

The result is a list describing the possible connection options and their current default values. Each entry in the list is a sublist of the format:

{optname label dispchar dispsize value}

where the optname is usable as an option in pg_connect -conninfo.

Description

pg_conndefaults returns info about the connection options available in pg_connect -conninfo and the current default value for each option.

Usage

pg_conndefaults