specifying repeatable read in PGOPTIONS

Hi,

I recently had the need to bury the used isolation level in the
connection string, but it turns out that doesn't work that well...

PGOPTIONS='-c default_transaction_isolation=serializable' \
psql ... -c "SHOW default_transaction_isolation"
works well enough, but
PGOPTIONS='-c default_transaction_isolation=repeatable read' \
psql ... -c "SHOW default_transaction_isolation"
doesn't, because of the whitespace. I couldn't come up with any adequate
quoting.

I'd like to propose adding aliases with dashes instead of spaces to the
isolation_level_options array? I'd even like to backport it, because it
makes benchmarking across versions unneccessarily hard.

Additionally we might want to think about a bit better quoting support
for such options?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services