Valid characters for PostgreSQL session parameters
0
votes
1
answer
126
views
Where can I find the list of characters which are valid for PostgreSQL configuration parameter names? By trial and error I found that '.' and '_' are valid, but ':' isn't. Quoting doesn't seem to help.
set claims.custom_id to asdf; -- accepted
set "claims.custom:id" to asdf; -- invalid configuration parameter name
The PostgreSQL docs don't seem to cover this point - https://www.postgresql.org/docs/current/config-setting.html
Asked by Isac Casapu
(173 rep)
Jun 7, 2022, 10:27 AM
Last activity: Jun 7, 2022, 10:51 AM
Last activity: Jun 7, 2022, 10:51 AM