sql_languages

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.