Re: escape vs. bytea in config

2023-03-07 Thread Peter J. Holzer
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

Re: escape vs. bytea in config

2023-03-07 Thread Laurenz Albe
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'); > ┌┐ > │

escape vs. bytea in config

2023-03-07 Thread Mathias Mayrhofer
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