On 09/02/2021 14:40, hubert depesz lubaczewski wrote: > Hi, > question from IRC, but I couldn't find an answer. > > I can set custom guc with - in name, but I can't figure out how to > select it. > > Without minus, it works great: > > =$ psql -X -c 'show custom.guc' > ERROR: unrecognized configuration parameter "custom.guc" > > =$ psql -X -c "alter user depesz set custom.guc = '123'" > ALTER ROLE > > =$ psql -X -c 'show custom.guc' > custom.guc > ------------ > 123 > (1 row) > > If I'd try to set variable with - in name: > > $ alter user depesz set custom.bad-guc = '1a'; > ERROR: syntax error at or near "-" > LINE 1: alter user depesz set custom.bad-guc = '1a'; Have you tried enclosing "bad-guc" in double quotes? Eddy
