Search PostgreSQL documentation

Configuration ParametersManual ChaptersPG18F.3.1. Configuration Parameters There are several configuration parameters that control the behavior of auto_explain. Note that the default behavior is to do nothing, so you must set at leas…Configuration Parameters Configuration ParametersManual ChaptersPG18F.4.1. Configuration Parameters basebackup_to_shell.command (string) The command which the server should execute for each archive generated by the backup process. If %f occurs in the command…Configuration Parameters Configuration ParametersManual ChaptersPG18F.5.1. Configuration Parameters basic_archive.archive_directory (string) The directory where the server should copy WAL segment files. This directory must already exist. The default is an em…Configuration Parameters Configuration ParametersManual ChaptersPG18F.20.4. Configuration Parameters isn.weak (boolean) # isn.weak enables the weak input mode, which allows ISN input values to be accepted even when their check digit is wrong. The default is …Configuration Parameters Configuration ParametersManual ChaptersPG18F.24.1. Configuration Parameters passwordcheck.min_password_length (integer) The minimum acceptable password length in bytes. The default is 8. Only superusers can change this setting. Note …Configuration Parameters Configuration ParametersManual ChaptersPG18F.26.7. Configuration Parameters There is one configuration parameter that controls the behavior of pgcrypto. pgcrypto.builtin_crypto_enabled (enum) # pgcrypto.builtin_crypto_enabled determi…Configuration Parameters Configuration ParametersManual ChaptersPG18F.30.2. Configuration Parameters pg_prewarm.autoprewarm (boolean) Controls whether the server should run the autoprewarm worker. This is on by default. This parameter can only be set at serv…Configuration Parameters Configuration ParametersManual ChaptersPG18F.32.4. Configuration Parameters pg_stat_statements.max (integer) pg_stat_statements.max is the maximum number of statements tracked by the module (i.e., the maximum number of rows in the pg…Configuration Parameters Configuration ParametersManual ChaptersPG18F.38.9. Configuration Parameters postgres_fdw.application_name (string) # Specifies a value for application_name configuration parameter used when postgres_fdw establishes a connection to a …Configuration Parameters Configuration ParametersManual ChaptersPG1831.2.8. Configuration Parameters When running the tests against an existing installation, some non-default parameter settings could cause the tests to fail. For example, changing parameters …Configuration Parameters Configuration SettingsManual ChaptersPG1829.12. Configuration Settings Logical replication requires several configuration options to be set. These options are relevant only on one side of the replication.Configuration Settings Configuration Settings FunctionsManual ChaptersPG189.28.1. Configuration Settings Functions Table 9.95 shows the functions available to query and alter run-time configuration parameters. Table 9.95. Configuration Settings Functions Function …Configuration Settings Functions Configuration TestingManual ChaptersPG1812.8.1. Configuration Testing The function ts_debug allows easy testing of a text search configuration. ts_debug([ config regconfig, ] document text, OUT alias text, OUT description text, OU…Configuration Testing ConfigurationsManual ChaptersPG1812.1.3. Configurations The above are all simple text search examples. As mentioned before, full text search functionality includes the ability to do many more things: skip indexing certain w…Configurations configure Complains About a Failed Test ProgramManual ChaptersPG1817.7.4.2. configure Complains About a Failed Test Program If configure complains about a failed test program, this is probably a case of the run-time linker being unable to find some library…configure Complains About a Failed Test Program configure Environment VariablesManual ChaptersPG1817.3.4. configure Environment Variables In addition to the ordinary command-line options described above, configure responds to a number of environment variables. You can specify environment…configure Environment Variables configure OptionsManual ChaptersPG1817.3.3. configure Options configure's command line options are explained below. This list is not exhaustive (use ./configure --help to get one that is). The options not covered here are mean…configure Options Configuring the ColorsManual ChaptersPG18N.2. Configuring the Colors The actual colors to be used are configured using the environment variable PG_COLORS (note plural). The value is a colon-separated list of key=value pairs. The ke…Configuring the Colors ConflictsManual ChaptersPG1829.7. Conflicts Logical replication behaves similarly to normal DML operations in that the data will be updated even if it was changed locally on the subscriber node. If incoming data violat…Conflicts CONNECTManual ChaptersPG18CONNECT CONNECT — establish a database connection Synopsis CONNECT TO connection_target [ AS connection_name ] [ USER connection_user ] CONNECT TO DEFAULT CONNECT connection_user DATABASE co…CONNECT connect_timeoutCommand-line ToolsPG18connect_timeout Maximum time to wait while connecting, in seconds (write as a decimal integer, e.g., 10). Zero, negative, or not specified means wait indefinitely. This timeout applies separ…Database Connection Control Functions › Parameter Key Words connectbyFunctionsPG18connectby ( relname text, keyid_fld text, parent_keyid_fld text [, orderby_fld text ], start_with text, max_depth integer [, branch_delim text ] ) → setof record Produces a representation of…tablefunc — functions that return tables (crosstab and others) › Functions Provided connectbyManual ChaptersPG18F.43.1.5. connectby connectby(text relname, text keyid_fld, text parent_keyid_fld [, text orderby_fld ], text start_with, int max_depth [, text branch_delim ]) The connectby function produce…connectby Connecting to a DatabaseManual ChaptersPG18Connecting to a Database psql is a regular PostgreSQL client application. In order to connect to a database you need to know the name of your target database, the host name and port number o…Connecting to a Database Connecting to the Database ServerManual ChaptersPG1834.2.1. Connecting to the Database Server One connects to a database using the following statement: EXEC SQL CONNECT TO target [AS connection-name] [USER user-name]; The target can be specif…Connecting to the Database Server Connection ManagementManual ChaptersPG18F.38.3. Connection Management postgres_fdw establishes a connection to a foreign server during the first query that uses a foreign table associated with the foreign server. By default this c…Connection Management Connection Management OptionsManual ChaptersPG18F.38.1.10. Connection Management Options By default, all connections that postgres_fdw establishes to foreign servers are kept open in the local session for re-use. keep_connections (boolean…Connection Management Options Connection OptionsManual ChaptersPG18F.38.1.1. Connection Options A foreign server using the postgres_fdw foreign data wrapper can have the same options that libpq accepts in connection strings, as described in Section 32.1.2, …Connection Options Connection SettingsManual ChaptersPG1819.3.1. Connection Settings listen_addresses (string) Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications. The value takes the form of …Connection Settings Connection Status FunctionsManual ChaptersPG1832.2. Connection Status Functions These functions can be used to interrogate the status of an existing database connection object. Tip libpq application programmers should be careful to main…Connection Status Functions Connection StringsManual ChaptersPG1832.1.1. Connection Strings Several libpq functions parse a user-specified string to obtain connection parameters. There are two accepted formats for these strings: plain keyword/value string…Connection Strings Connection URIsManual ChaptersPG1832.1.1.2. Connection URIs The general form for a connection URI is: postgresql://[userspec@][hostspec][/dbname][?paramspec] where userspec is: user[:password] and hostspec is: [host][:port][…Connection URIs connection_limitsExtensionsExtensionsEnforce connection quotas by user, database, source IP or hostname, including combined rules. connection-quota ip-address security connection_limits AdministrationAdministration · Extensions Connections and AuthenticationManual ChaptersPG1819.3. Connections and AuthenticationConnections and Authentication conninfoExtensionsExtensionsParse, validate, and inspect default values for PostgreSQL libpq conninfo strings conninfo UtilitiesUtilities · Extensions ConstantsManual ChaptersPG184.1.2. Constants There are three kinds of implicitly-typed constants in PostgreSQL: strings, bit strings, and numbers. Constants can also be specified with explicit types, which can enable m…Constants Constants of Other TypesManual ChaptersPG184.1.2.7. Constants of Other Types A constant of an arbitrary type can be entered using any one of the following notations: type 'string' 'string'::type CAST ( 'string' AS type ) The string c…Constants of Other Types constr_name_unifExtensionsExtensionsUniforms the names of constraints on base tables. constraints naming constr_name_unif AdministrationAdministration · Extensions Constraint NamingManual ChaptersPG18Constraint Naming The SQL standard says that table and domain constraints must have names that are unique across the schema containing the table or domain. PostgreSQL is laxer: it only requi…Constraint Naming constraint_column_usageManual ChaptersPG1835.18. constraint_column_usage The view constraint_column_usage identifies all columns in the current database that are used by some constraint. Only those columns are shown that are contain…constraint_column_usage