I have this query in Postgres that returns a hash value for every row of my table: SELECT md5(CAST((f.*)AS text)) FROM my_table f; I want to attach each hash to its corresponding row. How would I take the results for…
I have a system that writes its log into the Postgres database. And I want to analyse data after a specific event to tell how this system works. So status 9, in my case, acts like a trigger. After the…
This fails with tlsv1 alert unknown ca psql -h localhost -p 4566 -d dev -U root --set=sslmode=disable This works: psql "port=4566 host=localhost user=root dbname=dev sslmode=disable" Why? Why does one work when the other does not? Is the --set ignored? Is…
I am trying to translate a T-SQL Query to PostgreSQL and one part of the query contains the string function CHARINDEX () which I am not able to translate to PgSQL. Here is the part of the query with the…
Imagine 2 table with the same structure but that might have some rows not equal for the same primary key. What really happen when using a where clause like this : " where table1.* <> table2.* " ? I "used"…
I have the following table: Quarter Start 30/12/2016 31/03/2017 30/06/2017 29/09/2017 29/12/2017 30/03/2018 29/06/2018 28/09/2018 28/12/2018 29/03/2019 28/06/2019 27/09/2019 27/12/2019 27/03/2020 26/06/2020 25/09/2020 01/01/2021 02/04/2021 02/07/2021 01/10/2021 31/12/2021 01/04/2022 01/07/2022 30/09/2022 30/12/2022 24/03/2023 30/06/2023 29/09/2023 29/12/2023 29/03/2024 28/06/2024 27/09/2024 03/01/2025…
Does anyone know what this actually does? There appears to be two different timezones, a Session timezone and a Database time zone. The former is clear, it causes timezones with timestamp to be converted from a text representation in psql…
I saw this answer how do I select AVG of multiple columns on a single row but I have some rows which is the value is 0 and it's throwing an error division by zero when I try to use…
The question: Add a gender field. Ensure the field will only accept ‘M’ or ‘F’ and the default value should be ‘F’ PostgresSQL code: alter table Patient add Gender varchar(1) default 'F' ,Check (Gender = 'M' or Gender = 'F');…
A Kafka topic for my table is not created when using the debezium/connect Docker image. Here's how I'm starting the container: docker run -it --rm --name debezium -p 8083:8083 -e GROUP_ID=1 -e CONFIG_STORAGE_TOPIC=my-connect-configs -e OFFSET_STORAGE_TOPIC=my-connect-offsets -e BOOTSTRAP_SERVERS=192.168.56.1:9092 -e CONNECT_NAME=my-connector -e…