导出pgsql数据库中的所有表信息

select a.relname as name , b.description as value from pg_class a
left join (select * from pg_description where objsubid =0 ) b on a.oid = b.objoid
where a.relname in (select tablename from pg_tables where schemaname = 'public')
order by a.relname asc