PostgreSQL常用语句1

发布时间：2020-12-13 16:39:40 所属栏目：百科来源：网络整理

导读：--查询出t_test表的relownerselect c.relname,c.relowner,a.rolname from pg_class c,pg_authid a where c.relowner=a.oid and c.relname='t_test';--查询出某个索引的索引类型：select c.relname,a.amname from pg_class c,pg_am awhere c.relam=a.oid and

--查询出t_test表的relowner
select c.relname,c.relowner,a.rolname 
from pg_class c,pg_authid a where c.relowner=a.oid and c.relname='t_test';

--查询出某个索引的索引类型：
select c.relname,a.amname from pg_class c,pg_am a
where c.relam=a.oid and c.relname='tab_lei_1_c2_idx'

--查询出PG索引的类型：
select oid,* from pg_am

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!