Below, why
- the pattern
\dt sql_features
doesn't print the tablesql_features
(in the schemainformation_schema
), - but the pattern
\dt pg_cast
prints the tablepg_cast
(in the schemapg_catalog
)?
dbnccl03=# \conninfo
You are connected to database "dbnccl03" as user "pginc" via socket in "/tmp" at port "4900".
# There a table sql_features in the schema information_schema.
dbnccl03=# \dt information_schema.sql_features
List of relations
Schema | Name | Type | Owner
--------------------+--------------+-------+-------
information_schema | sql_features | table | pginc
(1 row)
# But the table is not listed with the pattern `sql_features`.
dbnccl03=# \dt sql_features
Did not find any relation named "sql_features".
# But in this case, why it works with the pattern `pg_cast`?
dbnccl03=# \dt pg_cast
List of relations
Schema | Name | Type | Owner
------------+---------+-------+-------
pg_catalog | pg_cast | table | pginc
(1 row)
# Just in case it's relevant here.
dbnccl03=# SHOW search_path;
search_path
-----------------
"$user", public
(1 row)
dbnccl03=# SELECT version();
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 12.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
(1 row)
Answer:
Related with:
pg_catalog
schema is automatically included in the search path: