Client Connection Defaults
Dossier URLs remain flat; this category exists only to organize browsing and the sidebar.
DateStyle
DateStyle is the PostgreSQL setting that defines the display format for date and time values.
IntervalStyle
IntervalStyle is the PostgreSQL setting that defines the display format for interval values.
TimeZone
TimeZone is the PostgreSQL setting that defines the time zone for displaying and interpreting time stamps.
bytea_output
bytea_output is the PostgreSQL setting that defines the output format for bytea.
check_function_bodies
check_function_bodies is the PostgreSQL setting that controls whether PostgreSQL checks routine bodies during CREATE FUNCTION and CREATE PROCEDURE.
client_encoding
client_encoding is the PostgreSQL setting that defines the client’s character set encoding.
client_min_messages
client_min_messages is the PostgreSQL setting that defines the message levels that are sent to the client.
createrole_self_grant
createrole_self_grant is the PostgreSQL setting that defines whether a CREATEROLE user automatically grants the role to themselves, and with which options.
default_table_access_method
default_table_access_method is the PostgreSQL setting that defines the default table access method for new tables.
default_tablespace
default_tablespace is the PostgreSQL setting that defines the default tablespace to create tables and indexes in.
default_text_search_config
default_text_search_config is the PostgreSQL setting that defines default text search configuration.
default_toast_compression
default_toast_compression is the PostgreSQL setting that defines the default compression method for compressible values.
default_transaction_deferrable
default_transaction_deferrable is the PostgreSQL setting that defines the default deferrable status of new transactions.
default_transaction_isolation
default_transaction_isolation is the PostgreSQL setting that defines the transaction isolation level of each new transaction.
default_transaction_read_only
default_transaction_read_only is the PostgreSQL setting that defines the default read-only status of new transactions.
dynamic_library_path
dynamic_library_path is the PostgreSQL setting that defines the path for dynamically loadable modules.
event_triggers
event_triggers is the PostgreSQL setting that controls whether PostgreSQL enables event triggers.
extension_control_path
extension_control_path is the PostgreSQL setting that defines the path for extension control files.
extra_float_digits
extra_float_digits is the PostgreSQL setting that defines the number of digits displayed for floating-point values.
gin_fuzzy_search_limit
gin_fuzzy_search_limit is the PostgreSQL setting that defines the maximum allowed result for exact search by GIN.
gin_pending_list_limit
gin_pending_list_limit is the PostgreSQL setting that defines the maximum size of the pending list for GIN index.
icu_validation_level
icu_validation_level is the PostgreSQL setting that defines the log level for reporting invalid ICU locale strings.
idle_in_transaction_session_timeout
idle_in_transaction_session_timeout is the PostgreSQL setting that defines the maximum allowed idle time between queries, when in a transaction.
idle_session_timeout
idle_session_timeout is the PostgreSQL setting that defines the maximum allowed idle time between queries, when not in a transaction.
jit_provider
jit_provider is the PostgreSQL setting that selects the JIT provider.
lc_messages
lc_messages is the PostgreSQL setting that defines the language in which messages are displayed.
lc_monetary
lc_monetary is the PostgreSQL setting that defines the locale for formatting monetary amounts.
lc_numeric
lc_numeric is the PostgreSQL setting that defines the locale for formatting numbers.
lc_time
lc_time is the PostgreSQL setting that defines the locale for formatting date and time values.
local_preload_libraries
local_preload_libraries is the PostgreSQL setting that lists unprivileged shared libraries to preload into each backend.
lock_timeout
lock_timeout is the PostgreSQL setting that defines the maximum allowed duration of any wait for a lock.
restrict_nonsystem_relation_kind
restrict_nonsystem_relation_kind is the PostgreSQL setting that prohibits access to non-system relations of specified kinds.
row_security
row_security is the PostgreSQL setting that controls whether PostgreSQL enables row security.
search_path
search_path is the PostgreSQL setting that defines the schema search order for names that are not schema-qualified.
session_preload_libraries
session_preload_libraries is the PostgreSQL setting that lists shared libraries to preload into each backend.
session_replication_role
session_replication_role is the PostgreSQL setting that defines the session’s behavior for triggers and rewrite rules.
shared_preload_libraries
shared_preload_libraries is the PostgreSQL setting that lists shared libraries to preload into server.
statement_timeout
statement_timeout is the PostgreSQL setting that defines the maximum allowed duration of any statement.
temp_tablespaces
temp_tablespaces is the PostgreSQL setting that defines the tablespace(s) to use for temporary tables and sort files.
timezone_abbreviations
timezone_abbreviations is the PostgreSQL setting that selects a file of time zone abbreviations.
transaction_deferrable
transaction_deferrable is the PostgreSQL setting that controls whether PostgreSQL should defer a read-only serializable transaction until it can be executed with no possible serialization failures.
transaction_isolation
transaction_isolation is the PostgreSQL setting that defines the current transaction’s isolation level.
transaction_read_only
transaction_read_only is the PostgreSQL setting that defines the current transaction’s read-only status.
transaction_timeout
transaction_timeout is the PostgreSQL setting that defines the maximum allowed duration of any transaction within a session (not a prepared transaction).
vacuum_cleanup_index_scale_factor
vacuum_cleanup_index_scale_factor is the PostgreSQL setting that defines the number of tuple inserts prior to index cleanup as a fraction of reltuples.
xmlbinary
xmlbinary is the PostgreSQL setting that defines how binary values are to be encoded in XML.
xmloption
xmloption is the PostgreSQL setting that defines whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.