pg常用sql小记

select oid,datname from pg_databases;
select * from pg_stat_all_tables where relname ='';
select * from pg_indexes where tablename ='表名';
select pg_relation_filepath('tb1');
select 'tb1'::regclass::oid;
select 2619::regclass

posted @ 2026-09-06 11:59  红丿领巾  阅读(4)  评论(0)    收藏  举报