I have the following selection: SELECT posm.id AS org_scope_metric_id, cc.code AS control_code, ccp.code AS part_code, pop.id AS program_id FROM public.org_scope_metric posm JOIN public.org_metric pom ON pom.id = posm.metric_id JOIN compliance.metric cm ON cm.id = pom.metric_id JOIN compliance.control_part_metric ccpm ON ccpm.metric_id…
I want to group all entries in my table by their user_type property. However the user_type entries exist in a {type of user} {date account was created} format, e.g. id | user_type -------------- 01 | 'admin 2024-03-01' 02 | 'admin…
I have a table like this: CREATE TABLE "users" ( id serial PRIMARY KEY, town text NOT NULL, street text not null, building text ); I want to be able to store unique entries by 3 columns "town", "street" and…
I have a table that has a jsonb foo with below nested structure foo: {"bar":[{"baz":["special string"]}]} I want to query in psql for all records whose foo.bar can contain an object with the array value at baz containing the "special…
I'm having a problem with connecting my Dockerized FastAPI project with my already existing PostgreSQL database which is running in its own container. When I run the API locally I am able to connect to the Postgres on localhost:5432, but…
My table has some null and empty strings, these look ugly when I query the table so I want to replace them with other values. I don't own the data so I can't modify the table itself, this needs to…
I have such an example of tables: table1: col 1 col2 col3 col4 1 a x1 asdc 2 b x2 czxa 3 c x3 xfsdaa table2: col2 col3 l x56 q x99 All I want is to receive such a…
Is there a way to define postgres range partition tables using inequality signs to limit values? my table is defined as follows: CREATE TABLE public.products_locations ( id UUID NOT NULL, product_id UUID NOT NULL, latitude NUMERIC NULL, longitude NUMERIC NULL,…
I struggle with creating a performant select of the database. Following case: A booking has 2 attributes departure and arrival. Both attributes are type date. I want to select all Persons with bookings with departure: 1.month.ago and no Booking in…
Is there any opensource tool or application available for migrating data from CSV file/s to MongoDB and Postgres Databases ? The tool should be able to take in the dataSource, in our case the CSV file , and we should…