> 回复的原邮件
> 发件人 Pavel Stehule
> 日期 2023年06月26日 17:51
> 收件人 陈锡汉
> 抄送至 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
> napsal:
>
>> H
po 26. 6. 2023 v 9:19 odesílatel Pavel Stehule
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_ac
Hi
po 26. 6. 2023 v 8:39 odesílatel 陈锡汉 napsal:
> Hello,I use multi-schemas in one database in Postgres,such as
>
> ```
> Postgres(instance)
> MyDB
>public
>MySchema1
> table1
> table2
>MySchema2
> table1
> table2
>MySchema3
> table1
> table2
> ```
