32.30. 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.

Table 32-28. sql_languages Columns

NameData TypeDescription
sql_language_sourcecharacter_data The name of the source of the language definition; always ISO 9075, that is, the SQL standard
sql_language_yearcharacter_data The year the standard referenced in sql_language_source was approved; currently 1999
sql_language_comformancecharacter_data The standard conformance level for the language binding. For ISO 9075:1999 this is always CORE.
sql_language_integritycharacter_dataAlways null (This value is relevant to an earlier version of the SQL standard.)
sql_language_implementationcharacter_dataAlways null
sql_language_binding_stylecharacter_data The language binding style, either DIRECT or EMBEDDED
sql_language_programming_languagecharacter_data The programming language, if the binding style is EMBEDDED, else null. PostgreSQL only supports the language C.
of the function, if it is a built-in type, or