33.41. sql_features

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly.

The table sql_features contains information about which formal features defined in the SQL standard are supported by Postgres-XC. This is the same information that is presented in Appendix D. There you can also find some additional background information.

Table 33-39. sql_features Columns

NameData TypeDescription
feature_idcharacter_dataIdentifier string of the feature
feature_namecharacter_dataDescriptive name of the feature
sub_feature_idcharacter_dataIdentifier string of the subfeature, or a zero-length string if not a subfeature
sub_feature_namecharacter_dataDescriptive name of the subfeature, or a zero-length string if not a subfeature
is_supportedyes_or_no YES if the feature is fully supported by the current version of Postgres-XC, NO if not
is_verified_bycharacter_data Always null, since the Postgres-XC development group does not perform formal testing of feature conformance
commentscharacter_dataPossibly a comment about the supported status of the feature