SET feature

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: danydb(at)noalyss(dot)eu
Subject: SET feature
Date: 2022-10-28 10:14:06
Message-ID: 166695204625.630.3067402447013848509@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/15/sql-set.html
Description:

Hi,

I remember in version 9 , to use variable you had to change in the
postgresql.

Today it is easier , just use

SET SESSION myprefix.myvariable = 'whatever'

and all the transactions can use it , it is very useful in some cases, for
example to track the author of a change , you don't need to change all your
java/php/python code , just use a trigger on the table to fill up a column
"change_by"

I've checked the documentation and that feature is not explained at all, not
even in the SET Command.

Hope it helps

Regards,

Sparkx

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2022-10-28 10:50:47 Re: First Person being used (only occurs in 2 other places in all of documentation)
Previous Message Daniel Gustafsson 2022-10-28 09:30:12 Re: First Person being used (only occurs in 2 other places in all of documentation)