po 26. 6. 2023 v 12:23 odesílatel 陈锡汉 <cavonc...@163.com> napsal:
> I have no way to force users doing this… > Then there is only one possible way - via custom extension you can catch the SET SEARCH_PATH statement, and you can do this. If you cannot use own extension, then there is not any way. > > > ---- 回复的原邮件 ---- > 发件人 Pavel Stehule<pavel.steh...@gmail.com> <pavel.steh...@gmail.com> > 日期 2023年06月26日 17:51 > 收件人 陈锡汉<cavonc...@163.com> <cavonc...@163.com> > 抄送至 pgsql-general@lists.postgresql.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.steh...@gmail.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 >>> >>> >>> >>>