> 回复的原邮件
> 发件人 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
I have no way to force users doing this…
回复的原邮件
| 发件人 | 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
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
> ```
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
```
And It's open to my users,my users will run queries,
such as
User1:
```
set searc
