Re: bytea vs. pg_dump

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Here is a first cut at a new hex bytea input and output format. Example:
> ...
> SET bytea_output_hex = true;

> Should the configuration parameter be a boolean or an enum, opening
> possibilities for other formats?

Enum. If we do this then it seems entirely fair that someone might
want other settings someday. Also, it seems silly to pick a format
partly on the grounds that it's expansible, and then not make the
control GUC expansible. Perhaps

SET bytea_output = [ hex | traditional ]

regards, tom lane