Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enable input of NULL elements in arrays. When turned on, unquoted NULL in an array input value means a null value; otherwise it is taken literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warn about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. Skips privilege checks when reading or modifying large objects, for compatibility with PostgreSQL releases prior to 9.0. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quote all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enable synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
operator_precedence_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Emits a warning for constructs that changed meaning since PostgreSQL 9.4. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | operator_precedence_warning |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
operator_precedence_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Emits a warning for constructs that changed meaning since PostgreSQL 9.4. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | operator_precedence_warning |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |
array_nulls
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables input of NULL (case insensitive) to be considered as NULL value rather than the literal String 'NULL'. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | array_nulls |
backslash_quote
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Sets whether "\'" is allowed in string literals. |
| Data type | enumeration |
| Default value | safe_encoding |
| Allowed values | safe_encoding,on,off |
| Parameter type | dynamic |
| Documentation | backslash_quote |
escape_string_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Warns about backslash escapes in ordinary string literals. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | escape_string_warning |
lo_compat_privileges
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables backward compatibility mode for privilege checks on large objects. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | lo_compat_privileges |
operator_precedence_warning
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Emits a warning for constructs that changed meaning since PostgreSQL 9.4. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | operator_precedence_warning |
quote_all_identifiers
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | When generating SQL fragments, quotes all identifiers. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | quote_all_identifiers |
standard_conforming_strings
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Causes '...' strings to treat backslashes literally. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | standard_conforming_strings |
synchronize_seqscans
| Attribute | Value |
|---|---|
| Category | Version and Platform Compatibility / Previous PostgreSQL Versions |
| Description | Enables synchronized sequential scans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | synchronize_seqscans |