回复：How to show current schema of running queries in postgresql 13

I have no way to force users doing this…

---- 回复的原邮件 ----
| 发件人 | Pavel Stehule<pavel(dot)stehule(at)gmail(dot)com> |
| 日期 | 2023年06月26日 17:51 |
| 收件人 | 陈锡汉<cavonchen(at)163(dot)com> |
| 抄送至 | pgsql-general(at)lists(dot)postgresql(dot)org |
| 主题 | Re: How to show current schema of running queries in postgresql 13 |

po 26. 6. 2023 v 9:19 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> 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