Re: execution id

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: "Voillequin, Jean-Marc" <Jean-Marc(dot)Voillequin(at)moodys(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: execution id
Date: 2022-08-30 16:55:23
Message-ID: 20220830165523.GA32591@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Aug 30, 2022 at 04:22:45PM +0000, Voillequin, Jean-Marc wrote:
> Hello guys,
>
> Is there a kind of magical system administration function that returns a unique id each time a select/insert/update/delete statement is launched?

What is the usecase?

You can get something like this with statement_timestamp()

Best regards,

depesz

In response to

  • execution id at 2022-08-30 16:22:45 from Voillequin, Jean-Marc

Browse pgsql-sql by date

  From Date Subject
Next Message Inzamam Shafiq 2022-09-15 17:31:47 ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
Previous Message Voillequin, Jean-Marc 2022-08-30 16:32:29 RE: execution id