Although the value of the "statement_timeout" parameter in the config file in one of my Postgresql databases is "0", there is a timeout period in my database. What is the reason for this? config file: enter image description here When…
I'm currently using Docker Desktop and I'm encountering an issue with my database. I have been able to use the pgAdmin container without any problems. However, when I attempt to connect the server to the database, I get an error.…
I have three tables: forums with columns id, label, name discussions with columns id, name, creation_date, open, forum_id, user_id messages with columns id, content, date, updated_date, discussion_id, user_id I want to get each forum and for each forum get the…
I have the following table in PostgreSQL: id fid val -------------------------- 200 995 XXLL 200 996 XXLL 201 995 OOOP 201 996 OOOS 202 995 OKIL 202 996 OKIL 203 995 LLLL 203 996 CCCC What I am trying to…
I have 4 tenants - tenant1,tenant2,tenant3,tenant4,tenant5 and i am using spring boot, postgress database and flywaydb Migration to database version and auto create when new tenant registered. Base code : https://github.com/AnarSultanov/examples/tree/master/schema-based-multi-tenancy https://sultanov.dev/blog/schema-based-multi-tenancy-with-spring-data/ in my sql scripts i have added foreign…
I'm creating a constraint in a table so that none of 8 columns must be equal to each other. I wanted to do it like this: alter table mytable add constraint no_duplicate_values check (col_1 <> col_2 <> col__3 <> col__4…
I have a table with a field called recordTime of type timestamp without time zone. I want to select todays records only (i.e. since midnight). The records are sourced globally and arrive as UTC, so I need to select records…
Why do these two statements produce different dates? select 'test 1', date_trunc('day', current_date at time zone 'utc' ) union select 'test 2', date_trunc('day',current_timestamp at time zone 'utc' ) As I type (2:20pm local time, UK) the first statement tells me…
I am working on a project for migrating database from Informix to Postgresql and not able to find a replacement of "MATCHES" in Postgresql. Below is the sql query which I am trying to make work in Postgresql. SELECT DISTINCT…
How can I get filter the rows where the number of keys in a jsonb column object have a specific value? I've got a jsonb column that contains something like { "fri": "from_home", "mon": "from_home", "sat": "dont_work", "sun": "dont_work", "thu":…