PostgreSQL系统相关查询[1]
来源:互联网 发布:数据安全法规 编辑:程序博客网 时间:2024/05/05 05:06
PG 系统查询脚本--查询用户进程及文本SELECT a.pid AS Id, a.usename AS User, a.client_addr AS Host, a.client_port AS Port, datname AS db, query AS Command, a.state AS Idle, l.mode as State, query_start AS Time, CASE WHEN c.relname IS NOT NULL THEN 'Locked Object: ' || c.relname ELSE 'Locked Transaction:' || l.virtualtransaction END AS Info FROM pg_stat_activity a LEFT JOIN pg_locks l ON a.pid = l.pid LEFT JOIN pg_class c ON l.relation = c.oid ORDER BY a.pid ASC, c.relname ASC--查询表[2015-03-03 17:38:35.668] [002232] [localhost] [PGSQL]SELECT tablename, schemaname FROM pg_tables WHERE schemaname='public' ORDER BY schemaname, tablename--查询视图[2015-03-03 17:38:35.731] [002232] [localhost] [PGSQL]SELECT viewname, schemaname FROM pg_views WHERE schemaname='public' ORDER BY schemaname, viewname--查询所属视图及其定义SELECT c.oid, c.relname, c.relacl, pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.oid) AS definition, obj_description(c.oid), n.nspname FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'v'::"char" AND n.nspname = 'public' --查询架构名下表、表注释及表行数SELECT c.oid, obj_description(c.oid), c.relhasoids AS hasoids, n.nspname AS schemaname, c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, t.spcname AS "tablespace", c.relhasindex AS hasindexes, c.relhasrules AS hasrules, c.relhastriggers AS hastriggers, c.relacl, c.reltuples, ((SELECT count(*) FROM pg_inherits WHERE inhparent = c.oid) > 0) AS inhtable, i2.relname AS inhtablename, c.reloptions AS param FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace LEFT JOIN (pg_inherits i INNER JOIN pg_class c2 ON i.inhparent = c2.oid) i2 ON i2.inhrelid = c.oid WHERE (c.relkind = 'r'::"char") AND n.nspname = 'public'order by reltuples--查询数据库及所属用户和字符集SELECT d.datname, d.oid, pg_get_userbyid(d.datdba) AS owner, shobj_description(d.oid, 'pg_database') AS comment, t.spcname, d.datacl, d.datlastsysoid, d.encoding, pg_encoding_to_char(d.encoding) AS encodingname FROM pg_database d LEFT JOIN pg_tablespace t ON d.dattablespace=t.oid
--EOF
0 0
- PostgreSQL系统相关查询[1]
- Postgresql 相关系统表查询
- postgresql相关系统表查询(转载)
- Postgresql 系统相关函数介绍
- postgresql 相关命令1
- Postgresql相关
- postgresql相关
- postgresql查询
- postgresql查询所有系统表,当前用户,当前时间戳
- postgresql查询所有系统表,当前用户,当前时间戳
- android系统cpu资源相关查询
- cmd查询系统的相关命令
- PostgreSQL的相关连接
- postgresQL相关语句
- PostgreSQL相关进程分类
- PostgreSQL索引相关
- postgresql时间相关函数
- PostgreSQL相关配置
- 腾讯视频直播间 v9.6.695 官方正式版
- Mantle与Direct3D游戏效能大比拼
- Spring学习笔记之最小化xml配置
- sscanf进行字符串分离、提取。以及string与数值的相互转换
- Objective C 中的nil,Nil,NULL和NSNull理解
- PostgreSQL系统相关查询[1]
- IOCP的一些笔记
- du
- apt-get apt-cache
- vim的全选功能,删除
- 大型网站的浏览器缓存设置
- android中的Context类详解
- IOS开发中(null)与<null>的处理
- Creating Custom Views -