Find hidden Postgres tables

Question

I'm pretty new to postgres and I know that a \dt will show up the tables, `dtIs` will show tables and indexes but I'm looking for how to show/find hidden tables if any?

Community · Accepted Answer · 2017-05-23 11:53:15Z

3

To find tables in any schema of a database, you could check the catalog table pg_class

SELECT oid::regclass AS table_name
FROM   pg_class
WHERE  relname = 'my_table_name'
AND    relkind = 'r';

Note, this includes "invisible" tables, that are not in your search_path, and even temporary tables from other sessions that you cannot access at all. There are no other "hidden" tables.

Tables in other databases of the same cluster are not included.

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Oct 10, 2013 at 16:58

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find hidden Postgres tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related