2021年9月9日(木) 16:53 Tim Uckun <timuckun(at)gmail(dot)com>:
>
> This seems simple enough but it's not working.
>
> alter database dbname set "blah.blah" = 'test_value' ;
>
> The above statement returns with no errors.
>
> select current_setting('blah.blah')
>
> The above statement returns a record with null
Open a new database session and you should see the setting.
> Also how long does the "ALTER DATABASE SET" last? Will it survive a
> shutdown and restart?
Yes.
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com