diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-08-16 11:03:33 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-08-16 11:03:33 -0400 |
| commit | 9b5140fb503eb50634cd7e080d41f4d9af41e0a6 (patch) | |
| tree | a0b7e0dae28a8aaf32c4ccbb349fb469a084e99e | |
| parent | 3cda10f41bfed7e34b0db7013b66dd40a5f75926 (diff) | |
| download | postgresql-9b5140fb503eb50634cd7e080d41f4d9af41e0a6.tar.gz postgresql-9b5140fb503eb50634cd7e080d41f4d9af41e0a6.zip | |
Correct representation of foreign tables in information schema
tables.table_type is supposed to be 'FOREIGN' rather than 'FOREIGN
TABLE' according to the SQL standard.
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 2 | ||||
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index b85849b2588..e07ff35bca0 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -5456,7 +5456,7 @@ ORDER BY c.ordinal_position; <entry> Type of the table: <literal>BASE TABLE</literal> for a persistent base table (the normal table type), - <literal>VIEW</literal> for a view, <literal>FOREIGN TABLE</literal> + <literal>VIEW</literal> for a view, <literal>FOREIGN</literal> for a foreign table, or <literal>LOCAL TEMPORARY</literal> for a temporary table </entry> diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 5398271ad01..236f6be37e8 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -1914,7 +1914,7 @@ CREATE VIEW tables AS CASE WHEN nc.oid = pg_my_temp_schema() THEN 'LOCAL TEMPORARY' WHEN c.relkind IN ('r', 'p') THEN 'BASE TABLE' WHEN c.relkind = 'v' THEN 'VIEW' - WHEN c.relkind = 'f' THEN 'FOREIGN TABLE' + WHEN c.relkind = 'f' THEN 'FOREIGN' ELSE null END AS character_data) AS table_type, |