复制 c.relname as "Name",开发库 CASE c.relkind WHEN r THEN table WHEN v THEN view WHEN m THEN materialized view WHEN i THEN index WHEN S THEN sequence WHEN s THEN special WHEN f THEN foreign table END as "Type", pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (r,) AND n.nspname <> pg_catalog AND n.nspname <> information_schema AND n.nspname !~ ^pg_toast AND pg_catalog.pg_table_is_visible(c.oid) ORDER BY 1,2; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.