aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--doc/src/sgml/information_schema.sgml2
-rw-r--r--src/backend/catalog/information_schema.sql2
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,