PostgreSQL 显示快捷命令真实执行的 SQL
PostgreSQL 大约 2843 字需求
查看\dt
、\di
等快捷命令实际执行的SQL
语句。
方法一
启动psql
时指定-E
参数
psql -E
查看帮助
psql --help
输出
Input and output options:
-a, --echo-all echo all input from script
-b, --echo-errors echo failed commands
-e, --echo-queries echo commands sent to server
-E, --echo-hidden display queries that internal commands generate
方法二
注意:ECHO_HIDDEN
必须大写。
ECHO_HIDDEN
取值:noexec
/on
/off
。
noexec
:只打印使用的sql
,但不真正执行。
\set ECHO_HIDDEN on
on
z-blog=# \set ECHO_HIDDEN on
z-blog=# \dt
********* QUERY **********
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 't' THEN 'TOAST table' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam
WHERE c.relkind IN ('r','p','')
AND n.nspname <> 'pg_catalog'
AND n.nspname !~ '^pg_toast'
AND n.nspname <> 'information_schema'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
**************************
List of relations
Schema | Name | Type | Owner
--------+------------------------+-------+----------
public | dashboard_user | table | z-blog
public | english | table | z-blog
public | ip_pool | table | z-blog
public | ip_unknown | table | z-blog
public | link | table | z-blog
public | message_board | table | z-blog
public | post | table | z-blog
public | record_invalid_request | table | z-blog
public | record_page_view | table | z-blog
public | record_search | table | z-blog
public | topic | table | z-blog
(13 rows)
noexec
z-blog=# \set ECHO_HIDDEN noexec
z-blog=# \dt
********* QUERY **********
SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 't' THEN 'TOAST table' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam
WHERE c.relkind IN ('r','p','')
AND n.nspname <> 'pg_catalog'
AND n.nspname !~ '^pg_toast'
AND n.nspname <> 'information_schema'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
**************************
阅读 136 · 发布于 2023-11-01
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓

昵称:
随便看看
换一批
-
Redis 命令行显示中文阅读 3694
-
Linux 常用命令之网络相关命令阅读 2152
-
Windows 网络适配器显示:网络管理员已经禁用了 Internet 连接共享阅读 3741
-
Spring Boot 启动后首次请求比较慢阅读 3242
-
软考-系统架构设计师:数据库优化阅读 2438
-
curl 命令遇到重定向时请求重定向后地址阅读 3572
-
MySQL 排序阅读 1308
-
Spring Boot 使用 @WebFilter 指定 urlPatterns 失效问题阅读 771
-
Elasticsearch 使用查询表达式搜索阅读 2587
-
k6 压测 HTTPS 接口报 X509 certificate signed by unknown authority阅读 2264