各数据库视图基表查询语法

自用

MySQL

SHOW CREATE VIEW sys.innodb_lock_waits;

PostgreSQL

SELECT definition FROM pg_views  WHERE viewname = 'pg_stat_activity';

GaussDB

GaussDB视图基表的查询可以使用PG的语法

m_db=> SELECT definition FROM pg_views WHERE viewname = 'gs_session_stat_activity';


                                                                              definition



------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------
 SELECT s.datid, d.datname, s.pid, s.usesysid, u.usename, s.application_name, s.client_addr, s.client_hostname, s.client_port, s.backend_start, s.xact
_start, s.query_start, s.state_change, s.waiting, s.enqueue, s.state, CASE WHEN (s.srespool = 'unknown'::name) THEN u.respool ELSE s.srespool END AS r
esource_pool, s.query_id, s.query, s.unique_sql_id, s.trace_id FROM pg_database d, pg_stat_get_activity(NULL::bigint) s(datid, pid, sessionid, usesysi
d, application_name, state, query, waiting, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, enqueue,
query_id, srespool, global_sessionid, unique_sql_id, trace_id), mtd_user u WHERE (((((s.datid = d.oid)) AND ( (s.usesysid = u.usesysid)))) AND ( (s.da
tid = u.dbid)));
(1 row)