Search PostgreSQL documentation

EnvironmentManual ChaptersPG18Environment When --source-server option is used, pg_rewind also uses the environment variables supported by libpq (see Section 32.15). The environment variable PG_COLOR specifies whether to …Environment EnvironmentManual ChaptersPG18Environment The environment variable PG_COLOR specifies whether to use color in diagnostic messages. Possible values are always, auto and never.Environment EnvironmentManual ChaptersPG18Environment PGCLIENTENCODING Default character encoding used by clients. (The clients can override this individually.) This value can also be set in the configuration file. PGDATA Default da…Environment EnvironmentManual ChaptersPG18Environment COLUMNS # If \pset columns is zero, controls the width for the wrapped format and width for determining if wide output requires the pager or should be switched to the vertical fo…Environment EnvironmentManual ChaptersPG18Environment PGDATABASEPGHOSTPGPORTPGUSER Default connection parameters PG_COLOR Specifies whether to use color in diagnostic messages. Possible values are always, auto and never. This utilit…Environment EnvironmentManual ChaptersPG18Environment PGDATABASEPGHOSTPGPORTPGUSER Default connection parameters PG_COLOR Specifies whether to use color in diagnostic messages. Possible values are always, auto and never. This utilit…Environment EnvironmentManual ChaptersPG18Environment PGHOSTPGPORTPGUSER Default connection parameters. This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 32.15). …Environment EnvironmentManual ChaptersPG18Environment The environment variable PG_COLOR specifies whether to use color in diagnostic messages. Possible values are always, auto and never.Environment EnvironmentManual ChaptersPG18Environment PGDATABASEPGHOSTPGPORTPGUSER # Default connection parameters. This utility, like most other PostgreSQL utilities, uses the environment variables supported by libpq (see Section 3…Environment EnvironmentManual ChaptersPG18Environment The environment variable PG_COLOR specifies whether to use color in diagnostic messages. Possible values are always, auto and never.Environment EnvironmentManual ChaptersPG18Environment Some environment variables can be used to provide defaults for command-line options: PGBINOLD The old PostgreSQL executable directory; option -b/--old-bindir. PGBINNEW The new Po…Environment EnvironmentManual ChaptersPG18Environment PGDATA Data directory; see also the -p option. PG_COLOR Specifies whether to use color in diagnostic messages. Possible values are always, auto and never.Environment EnvironmentManual ChaptersPG18Environment PGHOSTPGPORTPGUSER Default connection parameters. This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 32.15). …Environment Environment VariablesManual ChaptersPG1817.5.2. Environment Variables If you installed into /usr/local/pgsql or some other location that is not searched for programs by default, you should add /usr/local/pgsql/bin (or whatever you…Environment Variables Environment VariablesManual ChaptersPG1832.15. Environment Variables The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb, PQsetdbLogin and PQsetdb if no …Environment Variables Environment VariablesManual ChaptersPG1844.11. Environment Variables Some of the environment variables that are accepted by the Python interpreter can also be used to affect PL/Python behavior. They would need to be set in the env…Environment Variables Environment VariablesManual ChaptersPG1831.4.1. Environment Variables Data directories are named according to the test filename, and will be retained if a test fails. If the environment variable PG_TEST_NOCLEAN is set, data direct…Environment Variables envvarExtensionsExtensionsFetch the value of an environment variable pg_envvar UtilitiesUtilities · Extensions eqlExtensionsExtensionsEncrypt Query Language provides PostgreSQL types, functions, operators, and index support for searchable encrypted data. dbdev encryption searchable-encryption sql eql SecuritySecurity · Extensions erfFunctionsReferenceerf Mathematical Functions And Operators 16 Error function erf ( double precision ) → double precision Error function 17 18 19 20Functions · Mathematical Functions And Operators erfcFunctionsReferenceerfc Mathematical Functions And Operators 16 Complementary error function (1 - erf(x), without loss of precision for large inputs) erfc ( double precision ) → double precision Complementary …Functions · Mathematical Functions And Operators erlang_cnodeExtensionsExtensionsErlang C-node bridge for connecting PostgreSQL sessions to Erlang or Elixir nodes. erlang elixir c-node rpc pg-erl Procedural languagesProcedural languages · Extensions errno Values of pgtypeslibManual ChaptersPG1834.6.7. errno Values of pgtypeslib PGTYPES_NUM_BAD_NUMERIC # An argument should contain a numeric variable (or point to a numeric variable) but in fact its in-memory representation was inval…errno Values of pgtypeslib Error and Notice Message FieldsManual ChaptersPG1854.8. Error and Notice Message Fields This section describes the fields that can appear in ErrorResponse and NoticeResponse messages. Each field type has a single-byte identification token. …Error and Notice Message Fields Error HandlingManual ChaptersPG1834.8. Error Handling This section describes how you can handle exceptional conditions and warnings in an embedded SQL program. There are two nonexclusive facilities for this. Callbacks can b…Error Handling Error HandlingManual ChaptersPG1832.5.1.3. Error Handling From the client's perspective, after PQresultStatus returns PGRES_FATAL_ERROR, the pipeline is flagged as aborted. PQresultStatus will report a PGRES_PIPELINE_ABORTE…Error Handling Error HandlingManual ChaptersPG1819.14. Error Handling exit_on_error (boolean) # If on, any error will terminate the current session. By default, this is set to off, so that only FATAL errors will terminate the session. res…Error Handling Error Handling in PL/TclManual ChaptersPG1842.8. Error Handling in PL/Tcl Tcl code within or called from a PL/Tcl function can raise an error, either by executing some invalid operation or by generating an error using the Tcl error c…Error Handling in PL/Tcl Error Message DifferencesManual ChaptersPG1831.2.1. Error Message Differences Some of the regression tests involve intentional invalid input values. Error messages can come from either the PostgreSQL code or from the host platform sys…Error Message Differences Error Message Style GuideManual ChaptersPG1855.3. Error Message Style Guide This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL. What Goes Where …Error Message Style Guide Error Reporting and LoggingManual ChaptersPG1819.8. Error Reporting and LoggingError Reporting and Logging error_on_nullFunctionsReferenceerror_on_null Comparison Functions And Operators 19 Checks if the input is the null value, generating an error if so; otherwise, returns the input. error_on_null ( anyelement ) → anyelement …Functions · Comparison Functions And Operators Errors and MessagesManual ChaptersPG1841.9. Errors and MessagesErrors and Messages escape_string_warningConfigurationReferenceescape_string_warning Version and Platform Compatibility 10 When on, a warning is issued if a backslash (\) appears in an ordinary string literal ('...' syntax) and standard_conforming_strin…Configuration · Version and Platform Compatibility Escaping Strings for Inclusion in SQL CommandsManual ChaptersPG1832.3.4. Escaping Strings for Inclusion in SQL Commands PQescapeLiteral char *PQescapeLiteral(PGconn *conn, const char *str, size_t length); PQescapeLiteral escapes a string for use within an…Escaping Strings for Inclusion in SQL Commands etcd_fdwExtensionsExtensionsForeign data wrapper for etcd pgrx etcd_fdw Foreign data wrappersForeign data wrappers · Extensions eva_pgExtensionsExtensionsEVA ICS pgrx extension for the EVA industrial IoT platform. industrial-iot pgrx eva_pg Functions and aggregatesFunctions and aggregates · Extensions eventExtensionsExtensionspub/sub data change event tracking system events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets event FeaturesFeatures · Extensions Event Callback ProcedureManual ChaptersPG1832.14.2. Event Callback Procedure PGEventProc # PGEventProc is a typedef for a pointer to an event procedure, that is, the user callback function that receives events from libpq. The signatu…Event Callback Procedure Event ExampleManual ChaptersPG1832.14.4. Event Example Here is a skeleton example of managing private data associated with libpq connections and results. /* required header for libpq events (note: includes libpq-fe.h) */ #…Event Example