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

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

po 26. 6. 2023 v 12:23 odesílatel 陈锡汉 <cavonchen@xxxxxxx> 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.stehule@xxxxxxxxx>
日期	2023年06月26日 17:51
收件人	陈锡汉<cavonchen@xxxxxxx>
抄送至	pgsql-general@xxxxxxxxxxxxxxxxxxxx
主题	Re: How to show current schema of running queries in postgresql 13

po 26. 6. 2023 v 9:19 odesílatel Pavel Stehule <pavel.stehule@xxxxxxxxx> 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