Client Connection Defaults / Statement Behavior

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_table_access_method

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default table access method for new tables.
Data type string
Default value heap
Allowed values heap
Parameter type read-only
Documentation default_table_access_method

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_toast_compression

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default compression method for compressible values.
Data type enumeration
Default value pglz
Allowed values pglz
Parameter type read-only
Documentation default_toast_compression

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

idle_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed idle time between queries, when not in a transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value temptblspace
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type enumeration
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_failsafe_age

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_multixact_failsafe_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_table_access_method

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default table access method for new tables.
Data type string
Default value heap
Allowed values heap
Parameter type read-only
Documentation default_table_access_method

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_toast_compression

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default compression method for compressible values.
Data type enumeration
Default value pglz
Allowed values pglz
Parameter type read-only
Documentation default_toast_compression

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

idle_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed idle time between queries, when not in a transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value temptblspace
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type enumeration
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_failsafe_age

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_multixact_failsafe_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_table_access_method

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default table access method for new tables.
Data type string
Default value heap
Allowed values heap
Parameter type read-only
Documentation default_table_access_method

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_toast_compression

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default compression method for compressible values.
Data type enumeration
Default value pglz
Allowed values pglz
Parameter type read-only
Documentation default_toast_compression

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

idle_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed idle time between queries, when not in a transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value temptblspace
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type enumeration
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_failsafe_age

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_failsafe_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
Data type integer
Default value 1600000000
Allowed values 1600000000
Parameter type read-only
Documentation vacuum_multixact_failsafe_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_table_access_method

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default table access method for new tables.
Data type string
Default value heap
Allowed values heap
Parameter type read-only
Documentation default_table_access_method

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value temptblspace
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type enumeration
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_cleanup_index_scale_factor

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Number of tuple inserts prior to index cleanup as a fraction of reltuples.
Data type numeric
Default value 0.1
Allowed values 0.1
Parameter type read-only
Documentation

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_table_access_method

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default table access method for new tables.
Data type string
Default value heap
Allowed values heap
Parameter type read-only
Documentation default_table_access_method

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type enumeration
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_cleanup_index_scale_factor

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Number of tuple inserts prior to index cleanup as a fraction of reltuples.
Data type numeric
Default value 0.1
Allowed values 0.1
Parameter type read-only
Documentation

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption

bytea_output

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the output format for values of type bytea. Valid values are hex (the default) and escape (the traditional PostgreSQL format).
Data type enumeration
Default value hex
Allowed values escape,hex
Parameter type dynamic
Documentation bytea_output

check_function_bodies

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Checks function bodies during CREATE FUNCTION.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation check_function_bodies

client_min_messages

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls the message levels that are sent to the client.
Data type enumeration
Default value notice
Allowed values debug5,debug4,debug3,debug2,debug1,log,notice,warning,error
Parameter type dynamic
Documentation client_min_messages

default_tablespace

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace to create tables and indexes in.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation default_tablespace

default_transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default deferrable status of each new transaction. It has no effect on read-write transactions or those operating at isolation levels lower than serializable.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_deferrable

default_transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description This parameter controls the default isolation level of each new transaction. The default is 'read committed'.
Data type enumeration
Default value read committed
Allowed values serializable,repeatable read,read committed,read uncommitted
Parameter type dynamic
Documentation default_transaction_isolation

default_transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default read-only status of each new transaction.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation default_transaction_read_only

gin_pending_list_limit

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum size of the pending list for GIN index.
Data type integer
Default value 4096
Allowed values 64-2097151
Parameter type dynamic
Documentation gin_pending_list_limit

idle_in_transaction_session_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration of any idling transaction.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation idle_in_transaction_session_timeout

lock_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any wait for a lock. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation lock_timeout

row_security

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Enables row security.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation

search_path

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the schema search order for names that are not schema-qualified.
Data type string
Default value \"$user\", public
Allowed values [A-Za-z0-9.\"$,_ -]+
Parameter type dynamic
Documentation search_path

session_replication_role

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Controls firing of replication-related triggers and rules for the current session.
Data type enumeration
Default value origin
Allowed values origin,replica,local
Parameter type dynamic
Documentation session_replication_role

statement_timeout

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the maximum allowed duration (in milliseconds) of any statement. 0 turns this off.
Data type integer
Default value 0
Allowed values 0-2147483647
Parameter type dynamic
Documentation statement_timeout

temp_tablespaces

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the default tablespace(s) to use for temporary tables and sort files if not specified in the CREATE command.
Data type string
Default value
Allowed values [A-Za-z._]*
Parameter type dynamic
Documentation temp_tablespaces

transaction_deferrable

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_deferrable

transaction_isolation

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's isolation level.
Data type string
Default value read committed
Allowed values read committed
Parameter type read-only
Documentation transaction_isolation

transaction_read_only

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets the current transaction's read-only status.
Data type boolean
Default value off
Allowed values off
Parameter type read-only
Documentation transaction_read_only

vacuum_cleanup_index_scale_factor

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Number of tuple inserts prior to index cleanup as a fraction of reltuples.
Data type numeric
Default value 0.1
Allowed values 0.1
Parameter type read-only
Documentation

vacuum_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to freeze row versions while scanning a table.
Data type integer
Default value 50000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_freeze_min_age

vacuum_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Age at which VACUUM should scan whole table to freeze tuples.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_freeze_table_age

vacuum_multixact_freeze_min_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Specifies the cutoff age (in multixacts) that VACUUM should use to decide whether to replace multixact IDs with a newer transaction ID or multixact ID while scanning a table.
Data type integer
Default value 5000000
Allowed values 0-1000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_min_age

vacuum_multixact_freeze_table_age

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description VACUUM performs a full table scan to freeze rows if the table has reached the age specified by this setting.
Data type integer
Default value 150000000
Allowed values 0-2000000000
Parameter type dynamic
Documentation vacuum_multixact_freeze_table_age

xmlbinary

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets how binary values are to be encoded in XML.
Data type enumeration
Default value base64
Allowed values base64,hex
Parameter type dynamic
Documentation xmlbinary

xmloption

Attribute Value
Category Client Connection Defaults / Statement Behavior
Description Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
Data type enumeration
Default value content
Allowed values content,document
Parameter type dynamic
Documentation xmloption