S
S
sound9012019-05-23 12:04:42
PostgreSQL
sound901, 2019-05-23 12:04:42

How to select all tables without views?

Can you please tell me how to select all current tables in the database, public scheme, but exclude views (Views)?

select table_name from information_schema.tables where table_schema not in ('information_schema', 'pg_catalog') and table_schema in ('public')

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Valery, 2019-05-23
@saund901

table_type != 'VIEW'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question