Re: How to show current schema of running queries in postgresql 13

po 26. 6. 2023 v 12:23 odesílatel 陈锡汉 <cavonchen(at)163(dot)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(dot)stehule(at)gmail(dot)com> <pavel(dot)stehule(at)gmail(dot)com>
> 日期 2023年06月26日 17:51
> 收件人 陈锡汉<cavonchen(at)163(dot)com> <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
>>>
>>>
>>>
>>>