Cara mengetahui Informasi Tables/Views PostgreSQL

select * from information_schema.tables a

where a.table_catalog = 'YOUR_DB_NAME' -- optional
and a.table_schema != 'information_schema'
and a.table_schema not like 'pg_%'

and a.table_type = 'BASE TABLE' -- table
and a.table_type = 'VIEW' -- view