Skip to content

Instantly share code, notes, and snippets.

@arlandism

arlandism/set_config.sql

Created August 17, 2021 15:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arlandism/350033058982968cd50c3a74ba91cad2 to your computer and use it in GitHub Desktop.
Save arlandism/350033058982968cd50c3a74ba91cad2 to your computer and use it in GitHub Desktop.
Download ZIP
Example of set_config expiring after current transaction is over
Raw
set_config.sql
arlandis=# begin transaction;
BEGIN
arlandis=*# select set_config('my.random.key', 'blahblah', true);
set_config
------------
blahblah
(1 row)
arlandis=*# select current_setting('my.random.key');
current_setting
-----------------
blahblah
(1 row)
arlandis=*# commit;
COMMIT
arlandis=# select current_setting('my.random.key');
current_setting
-----------------
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment