The sql_features view provides information about SQL standard features supported by PostgreSQL.
| Column name | Data type | Description |
|---|---|---|
feature_id |
character_data |
The identifier string of the feature. |
feature_name |
character_data |
The descriptive name of the feature. |
sub_feature_id |
character_data |
The identifier string of the subfeature, or a zero-length string if it is not a subfeature. |
sub_feature_name |
character_data |
The descriptive name of the subfeature, or a zero-length string if it is not a subfeature. |
is_supported |
yes_or_no |
Specifies whether the feature is fully supported by the current version of PostgreSQL (YES) or not (NO). |
is_verified_by |
character_data |
The value is always NULL, since the PostgreSQL development group does not perform formal testing of feature conformance. |
comments |
character_data |
A possible comment about the supported status of the feature. |