On 2023-03-07 11:53:29 +0100, Mathias Mayrhofer wrote:
> I came across the "bytea_output" configuration variable inside
> postgresql.conf.
> It seems to be affecting the "digest" function, but in a way I cannot
> understand.
No, it just affects the way bytea values are displayed.
The return valu
On Tue, 2023-03-07 at 11:53 +0100, Mathias Mayrhofer wrote:
> -- /etc/postgresql/14/main/postgresql.conf
> -- bytea_output = 'escape'
>
> db=> select encode(digest('mtmayr', 'sha256'), 'escape');
> ┌┐
> │
Dear Supportlist,
I came across the "bytea_output" configuration variable inside
postgresql.conf. It seems to be affecting the "digest" function, but in
a way I cannot understand.
When my postgresql 14 server executes the digest function, it considers
the "bytea_output" variable, but the out