Setting a session variable for a Postgres connection

Answered

Created January 19, 2021 14:03

Is it possible to issue the equivalent of either

SELECT set_config('app.current_tenant', '100', false); or

SET app.current_tenant = '100';

So that the value of app.current_tenant can be used for Row Level Security (RS)

Thanks !

2 comments

Yuriy Vinogradov

Created January 19, 2021 18:02

Yes you can do it in Data Source properties -> Options tab -> Startup script. Just put

SET app.current_tenant = '100'

there and restart session.

Created January 22, 2021 15:06

That worked, thank you

Please sign in to leave a comment.