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

Re: Detecting schema changes via WAL logs

On 19.02.22 17:42, Cal Mitchell wrote: Hello everyone, I’m building an open-source data integration tool (SQLpipe) and am now trying to incorporate CDC into the product. Is it possible to detect when schema changes happen via the WAL? The WAL doesn’t have to tell me /what/ was changed, it ju

Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

Hi Chow, Can you answer the below questions, please? - What is the pgaudit extension version? - What is the PostGIS and postgis_raster extensions version? - In which databases are PostGIS or postgis_raster extensions installed? - Can you add postgresql.auto.conf file? I suppose that the problem

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';