Sample Header Ad - 728x90

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