I have heard I should avoid cross join so my question is how you would rewrite this query without cross join ? SELECT p.*, po.*, pt.* FROM product p CROSS JOIN LATERAL ( SELECT json_agg(name) AS product_options FROM product_options po…
I have table which has store number and Fruits in it like below Store Number fruit 111 Apple 121 Orange 111 Pinable 132 Apple 145 Grapes 121 Apple 111 Apple I want to to add a generated column "Number of…
I select some tables with json_agg and json_build, all works but I got some data that I dont want it, My product_media (pm) is empty there are no images, if I use json_agg(json_build_object)) then I got 3x times all rows…
I'm trying to figure out a way to list all numbers between two columns (INT) and join them in a third column where all numbers are seperated. Eg. Column A Column B Column C 100 105 100;101;102;103;104;105 10 14 10;11;12;13;14…
I find my self sometimes needing to select many items of different tables based on a list of id's or other variables. Given that this list can contain thousands of elements, it is important for me that the filter does…
When a payment is received in my company's banking account, a webhook is triggered to our application, providing data related to the payment, including the payment label. This label is a string written by the client and can vary significantly…
Im building parameterised sql using pgp and wrapping the generated sql inside DO $$ END $$. Problem is when I try saving password (varchar) some of the password hashes contain $$ which causes issues since the psql is inside DO…
I'm currently facing an issue with my ECS tasks connection to RDS which are deployed by using AWS Copilot CLI. Despite ensuring that the ECS task and the RDS have the same VPC and appropriate security groups for connection. Interestingly,…
I'm a newbie to Kafka and started experimenting. I'm using this tutorial https://medium.com/high-alpha/data-stream-processing-for-newbies-with-kafka-ksql-and-postgres-c30309cfaaf8 I ran the following docker-compose.yml version: '2' services: postgres: image: 'debezium/postgres:11' environment: POSTGRES_PASSWORD: postgres command: postgres -c config_file=/home/config/postgresql.conf ports: - '5432:5432' volumes: - 'C:postgres-kafkaconfig:/home/config' - 'C:postgres-kafkaconfigpg_hba.conf:/home/config/pg_hba.conf' -…
I am trying to run a sql script upon a postgreSQL container in k8S If i run my commands in the command line one by one , it works. However if i run the script file it does not trying…