pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: 陈锡汉 <cavonchen@163.com>
To: pavel.stehule <pavel.stehule@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: 回复:How to show current schema of running queries in postgresql 13
Date: Mon, 26 Jun 2023 18:22:58 +0800 (GMT+08:00)
Message-ID: <66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com> (raw)
In-Reply-To: <CAFj8pRDZy6Ur6PXwmVTRah+XYgSw_714Yg2AxDn8RGtAPbtd=A@mail.gmail.com>
References: <cce56ad.74cd.188f66defe9.Coremail.cavonchen@163.com>
	<CAFj8pRBWHa7x0TEZ2WoBkU-Fe8NO0=T8m6OXyWCX9f0x6J93rg@mail.gmail.com>
	<CAFj8pRDZy6Ur6PXwmVTRah+XYgSw_714Yg2AxDn8RGtAPbtd=A@mail.gmail.com>

I have no way to force users doing this…



---- 回复的原邮件 ----
| 发件人 | Pavel Stehule<pavel.stehule@gmail.com> |
| 日期 | 2023年06月26日 17:51 |
| 收件人 | 陈锡汉<cavonchen@163.com> |
| 抄送至 | 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 <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





view thread (5+ messages)  latest in thread

Message-ID: <66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com>
Permalink:  ../66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com/
Also on:    postgresql.org/message-id/66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: cavonchen@163.com, pavel.stehule@gmail.com
  Subject: Re: 回复:How to show current schema of running queries in postgresql 13
  In-Reply-To: <66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com>
  References: <cce56ad.74cd.188f66defe9.Coremail.cavonchen@163.com> <CAFj8pRBWHa7x0TEZ2WoBkU-Fe8NO0=T8m6OXyWCX9f0x6J93rg@mail.gmail.com> <CAFj8pRDZy6Ur6PXwmVTRah+XYgSw_714Yg2AxDn8RGtAPbtd=A@mail.gmail.com> <66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox