sql_languages
| PostgreSQL 9.5.8 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 34. The Information Schema | Next |
The table sql_languages contains one row for each SQL language binding that is supported by PostgreSQL . PostgreSQL supports direct SQL and embedded SQL in C; that is all you will learn from this table.
This table was removed from the SQL standard in SQL:2008, so there are no entries referring to standards later than SQL:2003.
Table 34-43. sql_languages Columns
| Name | Data Type | Description |
|---|---|---|
| sql_language_source | character_data | The name of the source of the language definition; always ISO 9075 , that is, the SQL standard |
| sql_language_year | character_data | The year the standard referenced in sql_language_source was approved. |
| sql_language_conformance | character_data | The standard conformance level for the language binding. For ISO 9075:2003 this is always CORE . |
| sql_language_integrity | character_data | Always null (This value is relevant to an earlier version of the SQL standard.) |
| sql_language_implementation | character_data | Always null |
| sql_language_binding_style | character_data | The language binding style, either DIRECT or EMBEDDED |
| sql_language_programming_language | character_data | The programming language, if the binding style is EMBEDDED , else null. PostgreSQL only supports the language C. |