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');
> ┌┐
> │