# Client Connection Defaults

> Complete dossiers for 47 core PostgreSQL settings in Client Connection Defaults.
---

Dossier URLs remain flat; this category exists only to organize browsing and the sidebar.

---

Section pages:

- [DateStyle](/parameters/datestyle/): DateStyle is the PostgreSQL setting that defines the display format for date and time values.
- [IntervalStyle](/parameters/intervalstyle/): IntervalStyle is the PostgreSQL setting that defines the display format for interval values.
- [TimeZone](/parameters/timezone/): TimeZone is the PostgreSQL setting that defines the time zone for displaying and interpreting time stamps.
- [bytea_output](/parameters/bytea-output/): bytea_output is the PostgreSQL setting that defines the output format for bytea.
- [check_function_bodies](/parameters/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](/parameters/client-encoding/): client_encoding is the PostgreSQL setting that defines the client's character set encoding.
- [client_min_messages](/parameters/client-min-messages/): client_min_messages is the PostgreSQL setting that defines the message levels that are sent to the client.
- [createrole_self_grant](/parameters/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](/parameters/default-table-access-method/): default_table_access_method is the PostgreSQL setting that defines the default table access method for new tables.
- [default_tablespace](/parameters/default-tablespace/): default_tablespace is the PostgreSQL setting that defines the default tablespace to create tables and indexes in.
- [default_text_search_config](/parameters/default-text-search-config/): default_text_search_config is the PostgreSQL setting that defines default text search configuration.
- [default_toast_compression](/parameters/default-toast-compression/): default_toast_compression is the PostgreSQL setting that defines the default compression method for compressible values.
- [default_transaction_deferrable](/parameters/default-transaction-deferrable/): default_transaction_deferrable is the PostgreSQL setting that defines the default deferrable status of new transactions.
- [default_transaction_isolation](/parameters/default-transaction-isolation/): default_transaction_isolation is the PostgreSQL setting that defines the transaction isolation level of each new transaction.
- [default_transaction_read_only](/parameters/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](/parameters/dynamic-library-path/): dynamic_library_path is the PostgreSQL setting that defines the path for dynamically loadable modules.
- [event_triggers](/parameters/event-triggers/): event_triggers is the PostgreSQL setting that controls whether PostgreSQL enables event triggers.
- [extension_control_path](/parameters/extension-control-path/): extension_control_path is the PostgreSQL setting that defines the path for extension control files.
- [extra_float_digits](/parameters/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](/parameters/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](/parameters/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](/parameters/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](/parameters/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](/parameters/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](/parameters/jit-provider/): jit_provider is the PostgreSQL setting that selects the JIT provider.
- [lc_messages](/parameters/lc-messages/): lc_messages is the PostgreSQL setting that defines the language in which messages are displayed.
- [lc_monetary](/parameters/lc-monetary/): lc_monetary is the PostgreSQL setting that defines the locale for formatting monetary amounts.
- [lc_numeric](/parameters/lc-numeric/): lc_numeric is the PostgreSQL setting that defines the locale for formatting numbers.
- [lc_time](/parameters/lc-time/): lc_time is the PostgreSQL setting that defines the locale for formatting date and time values.
- [local_preload_libraries](/parameters/local-preload-libraries/): local_preload_libraries is the PostgreSQL setting that lists unprivileged shared libraries to preload into each backend.
- [lock_timeout](/parameters/lock-timeout/): lock_timeout is the PostgreSQL setting that defines the maximum allowed duration of any wait for a lock.
- [restrict_nonsystem_relation_kind](/parameters/restrict-nonsystem-relation-kind/): restrict_nonsystem_relation_kind is the PostgreSQL setting that prohibits access to non-system relations of specified kinds.
- [row_security](/parameters/row-security/): row_security is the PostgreSQL setting that controls whether PostgreSQL enables row security.
- [search_path](/parameters/search-path/): search_path is the PostgreSQL setting that defines the schema search order for names that are not schema-qualified.
- [session_preload_libraries](/parameters/session-preload-libraries/): session_preload_libraries is the PostgreSQL setting that lists shared libraries to preload into each backend.
- [session_replication_role](/parameters/session-replication-role/): session_replication_role is the PostgreSQL setting that defines the session's behavior for triggers and rewrite rules.
- [shared_preload_libraries](/parameters/shared-preload-libraries/): shared_preload_libraries is the PostgreSQL setting that lists shared libraries to preload into server.
- [statement_timeout](/parameters/statement-timeout/): statement_timeout is the PostgreSQL setting that defines the maximum allowed duration of any statement.
- [temp_tablespaces](/parameters/temp-tablespaces/): temp_tablespaces is the PostgreSQL setting that defines the tablespace(s) to use for temporary tables and sort files.
- [timezone_abbreviations](/parameters/timezone-abbreviations/): timezone_abbreviations is the PostgreSQL setting that selects a file of time zone abbreviations.
- [transaction_deferrable](/parameters/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](/parameters/transaction-isolation/): transaction_isolation is the PostgreSQL setting that defines the current transaction's isolation level.
- [transaction_read_only](/parameters/transaction-read-only/): transaction_read_only is the PostgreSQL setting that defines the current transaction's read-only status.
- [transaction_timeout](/parameters/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](/parameters/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](/parameters/xmlbinary/): xmlbinary is the PostgreSQL setting that defines how binary values are to be encoded in XML.
- [xmloption](/parameters/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.
