I have no way to force users doing this…
---- 回复的原邮件 ---- | 发件人 | Pavel Stehule<[email protected]> | | 日期 | 2023年06月26日 17:51 | | 收件人 | 陈锡汉<[email protected]> | | 抄送至 | [email protected] | | 主题 | Re: How to show current schema of running queries in postgresql 13 | po 26. 6. 2023 v 9:19 odesílatel Pavel Stehule <[email protected]> napsal: Hi no, there is nothing for this purpose. you can use application_name so user can do SET search_path=MySchema; SET application_name = 'MySchema'; SELECT * FROM ... and application name is visible from pg_stat_activity regards Pavel Stehule Thank you! Best regards, CavonChen
