Re: varchar::bytea fails when varchar contains backslash

Matthias Apitz wrote: > I wanted to look into a column of type varchar converting the content > with ::bytea to a hex string, but this fails when the column contains a > backslash: Yes, casting from text to bytea cannot be used for that. The convert_to() function must be used instead. Fr

varchar::bytea fails when varchar contains backslash

Hello, I wanted to look into a column of type varchar converting the content with ::bytea to a hex string, but this fails when the column contains a backslash: psql -Usisis -dtestdb psql (14.1) Geben Sie »help« für Hilfe ein. testdb=# select trenn from sik_fstab where name='EdvSelKenn';