Version and Platform Compatibility / Previous PostgreSQL Versions
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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for