From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/infoschema-tables.html | 82 ++++++++++++++++++++++++++++++++ 1 file changed, 82 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-tables.html (limited to 'doc/src/sgml/html/infoschema-tables.html') diff --git a/doc/src/sgml/html/infoschema-tables.html b/doc/src/sgml/html/infoschema-tables.html new file mode 100644 index 0000000..99d7e08 --- /dev/null +++ b/doc/src/sgml/html/infoschema-tables.html @@ -0,0 +1,82 @@ + +37.54. tables
37.54. tables
Prev UpChapter 37. The Information SchemaHome Next

37.54. tables #

+ The view tables contains all tables and views + defined in the current database. Only those tables and views are + shown that the current user has access to (by way of being the + owner or having some privilege). +

Table 37.52. tables Columns

+ Column Type +

+

+ Description +

+ table_catalog sql_identifier +

+

+ Name of the database that contains the table (always the current database) +

+ table_schema sql_identifier +

+

+ Name of the schema that contains the table +

+ table_name sql_identifier +

+

+ Name of the table +

+ table_type character_data +

+

+ Type of the table: BASE TABLE for a + persistent base table (the normal table type), + VIEW for a view, FOREIGN + for a foreign table, or + LOCAL TEMPORARY for a temporary table +

+ self_referencing_column_name sql_identifier +

+

+ Applies to a feature not available in PostgreSQL +

+ reference_generation character_data +

+

+ Applies to a feature not available in PostgreSQL +

+ user_defined_type_catalog sql_identifier +

+

+ If the table is a typed table, the name of the database that + contains the underlying data type (always the current + database), else null. +

+ user_defined_type_schema sql_identifier +

+

+ If the table is a typed table, the name of the schema that + contains the underlying data type, else null. +

+ user_defined_type_name sql_identifier +

+

+ If the table is a typed table, the name of the underlying data + type, else null. +

+ is_insertable_into yes_or_no +

+

+ YES if the table is insertable into, + NO if not (Base tables are always insertable + into, views not necessarily.) +

+ is_typed yes_or_no +

+

+ YES if the table is a typed table, NO if not +

+ commit_action character_data +

+

+ Not yet implemented +


Prev Up Next
37.53. table_privileges Home 37.55. transforms
\ No newline at end of file -- cgit v1.2.3