From 615c3849722ade16282750aa17658a2543fd2acf Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 28 Jun 2011 17:49:28 +0300 Subject: Implement the collation columns of various information schema views Fill in the collation columns of the views attributes, columns, domains, and element_types. Also update collation information in sql_implementation_info. --- doc/src/sgml/information_schema.sgml | 108 ++++++++++++++++++++++++++++++----- 1 file changed, 93 insertions(+), 15 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 396d3e76365..1c7ab9498ec 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -379,6 +379,53 @@ + + character_set_catalog + sql_identifier + Applies to a feature not available in PostgreSQL + + + + character_set_schema + sql_identifier + Applies to a feature not available in PostgreSQL + + + + character_set_name + sql_identifier + Applies to a feature not available in PostgreSQL + + + + collation_catalog + sql_identifier + + Name of the database containing the collation of the attribute + (always the current database), null if default or the data type + of the attribute is not collatable + + + + + collation_schema + sql_identifier + + Name of the schema containing the collation of the attribute, + null if default or the data type of the attribute is not + collatable + + + + + collation_name + sql_identifier + + Name of the collation of the attribute, null if default or the + data type of the attribute is not collatable + + + numeric_precision cardinal_number @@ -1321,19 +1368,29 @@ collation_catalog sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the database containing the collation of the column + (always the current database), null if default or the data type + of the column is not collatable + collation_schema sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the schema containing the collation of the column, null + if default or the data type of the column is not collatable + collation_name sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the collation of the column, null if default or the + data type of the column is not collatable + @@ -1996,19 +2053,29 @@ collation_catalog sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the database containing the collation of the domain + (always the current database), null if default or the data type + of the domain is not collatable + collation_schema sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the schema containing the collation of the domain, null + if default or the data type of the domain is not collatable + collation_name sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the collation of the column, null if default or the + data type of the domain is not collatable + @@ -2275,19 +2342,30 @@ ORDER BY c.ordinal_position; collation_catalog sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the database containing the collation of the element + type (always the current database), null if default or the data + type of the element is not collatable + collation_schema sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the schema containing the collation of the element + type, null if default or the data type of the element is not + collatable + collation_name sql_identifier - Applies to a feature not available in PostgreSQL + + Name of the collation of the element type, null if default or + the data type of the element is not collatable + @@ -3025,19 +3103,19 @@ ORDER BY c.ordinal_position; collation_catalog sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to parameter data types in PostgreSQL collation_schema sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to parameter data types in PostgreSQL collation_name sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to parameter data types in PostgreSQL @@ -3912,19 +3990,19 @@ ORDER BY c.ordinal_position; collation_catalog sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to return data types in PostgreSQL collation_schema sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to return data types in PostgreSQL collation_name sql_identifier - Applies to a feature not available in PostgreSQL + Always null, since this information is not applied to return data types in PostgreSQL -- cgit v1.2.3