Imagine I have rows of data in a postgres table, such as: Id Value 1 User_1 2 Region_3 3 User_2 And I want to select out values in a way that uses the part of Value before the _ character…
I have made a Django project with a postgresql backend and am trying to containerize it. This is my Dockerfile: FROM python:3.9 ENV PYTHONDONTWRITEBYTECODE 1 ENV PYTHONUNBUFFERED 1 WORKDIR /app COPY requirements.txt /app/ RUN pip install --no-cache-dir -r requirements.txt COPY…
I have large query that need's to be optimized. Upon generating explain plan using EXPLAIN(ANALYZE) I noticed that the query is using the disk space in sorting. Sort Method: external merge Disk: 201,816kB Worker 0: Sort Method: external merge Disk:…
I have docker-compose.yaml file containing this data: services: db: image: postgres restart: always environment: POSTGRES_PASSWORD: p2ostgres1 ports: - '6000:5432' volumes: - pgdata:/var/lib/postgresql/data volumes: pgdata: after running docker-compose up and making some changes to the database, i can access that database…
With a schema: CREATE TABLE foo ( id SERIAL UNIQUE, name VARCHAR(15) NOT NULL, domain VARCHAR(255), ); CREATE TABLE bar ( foo_id INT UNIQUE NOT NULL REFERENCES foo(id), passphrase VARCHAR ); I need to use: SELECT * FROM foo LEFT…
I'm making a Django app using a postgresql database for a family who need to coordinate their grocery purchases. Say one person has on their mobile device a full list of the groceries and is in the supermarket, buying and…
I am trying to avoid duplicate entries in the table based on type and names however the unique constraint not getting applied. CREATE TABLE IF NOT EXISTS test ( id integer NOT NULL DEFAULT nextval('threshold_retry.threshold_details_id_seq'::regclass), component_type text COLLATE pg_catalog."default" NOT…
I am currently engaged in learning to formulate queries on the Datalemur platform. Upon encountering a specific question, I diligently crafted a solution which successfully yielded the desired output. Regrettably, despite achieving the intended result, my solution failed to meet…
I am trying to add a date range to my sql query. The date range should change every quarter Example on April 1 2024 - The date range for the data should be trailing 12 months, ie it should look…
I have a table orders in Postgres with columns offer_id and date. I need to write a query which fills in all null cases in column offer_id, using the previous not-null value. I tried to use the window function lag()…