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