postgresql查数据库的表类型

SELECT 
    table_schema, 
    table_name, 
    table_type
FROM 
    information_schema.tables
WHERE 
    table_schema NOT IN ('pg_catalog', 'information_schema')
    AND table_type = 'BASE TABLE';