I have an postgres 16 DB in Docker container with volume. I wanted to hide standard postgres user and changed it's name to super (as example). Now I try to make something with any tables (DDL operations like ALTER TABLE)…
I can simply use LAG() to calculate the percentage change from my table (see below) of this month compared to the data 3 months ago or 1 year ago. But now, I want to get this result: calculate the sum…
I have a table that looks like this: id A B 1 A1 B1 2 A1 B2 3 A2 B2 4 A2 B3 Then I have a list of items for which I want to find the corresponding database rows.…
I expect the SQL-Statement to update a limited amounts of rows, instead of every row: UPDATE Join_Test_1 SET ANumber = 3 FROM Join_Test_1 AS ST1 INNER JOIN Join_Test_2 AS ST2 ON ST1.PKID = ST2.PKID; I expect the statement to behave…
I have the following table: recipe id | ingredients ----+-------------- 1 | "1,2,3" 2 | "3,4" 3 | "2" 4 | "1,2,3,4" I want to find all recipes containing ingredient "1", "3" or "4". How can I achieve that using…
This is my database design: CREATE TABLE post ( id INT, user_id INT, type_id INT ); I want to get a list of users who wrote posts of types 1 and 2 only. This seems to be working: select distinct…
I have an Azure Data Explorer (ADX) aka. Kusto instance in combination with a PostgreSQL Flexible Server (16.4) and want to access a the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the…
I am working with a PostgreSQL database and need to encrypt sensitive data fields (like SSN and email) for security purposes. However, I want to be able to query these encrypted fields efficiently, especially using WHERE clauses, without decrypting each…
We encountered a situation where CPU usage hit 100% due to a frequently running query. The issue resolved after performing a manual ANALYZE on the table involved in the query. However, I noticed the following: Auto-analyze ran at 11:46 UTC…
Flyway does not support Postgres 17, before it was 16 and the same error message occurred, I have changed the dependencies several times and it remains the same. Finally, I installed db 17 and the latest version of the flyway…