Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question