①表名
SELECT tablename FROM pg_tables
WHERE tablename NOT LIKE 'pg%'
AND tablename NOT LIKE 'sql_%'
②数据库名
SELECT datname FROM pg_database;
③列名
select *
from information_schema.columns
where table_name = 'final_back_pg_lv10'
原文链接：https://www.f2er.com/postgresql/195779.html