Postgres Pro
Downloads
Home   >   mailing lists

Re: How to show current schema of running queries in postgresql 13 - Mailing list pgsql-general

From Pavel Stehule
Subject Re: How to show current schema of running queries in postgresql 13
Date
Msg-id CAFj8pRDZy6Ur6PXwmVTRah+XYgSw_714Yg2AxDn8RGtAPbtd=A@mail.gmail.com
Whole thread Raw
In response to Re: How to show current schema of running queries in postgresql 13  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses 回复：How to show current schema of running queries in postgresql 13  (陈锡汉 <cavonchen@163.com>)
List pgsql-general
Tree view


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



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to show current schema of running queries in postgresql 13
Next
From: "Oduba, Ernest"
Date:
Subject: PostgreSQL Commercial Support