I was solving some SQL tasks and got confused with the following thing: CREATE TABLE data ( len INT ); INSERT INTO data (len) VALUES (NULL), (100), (200), (300), (400); suppose we've created such a table and we wanna count…
I am frontend engineer building something with supabase, I have written this postgres function DROP FUNCTION IF EXISTS get_schedule_checklist_data; CREATE OR REPLACE FUNCTION get_schedule_checklist_data( schedule_id UUID, blueprint_id_value UUID, event_type service_configuration_type ) RETURNS TABLE ( title TEXT, schedule_id UUID, checklist_id UUID,…
I am encountering a very odd issue with PostgreSQL running inside a Docker container on macOS. When attempting to create a table with using an initialization script, PostgreSQL erroneously reports that the relation already exists (even after a full pruning…
I have two tables, master and Details, and I need to generate a report that counts the occurrences of each status value for each remark. Here's the structure of my tables: Table: master m_id (Primary Key) remarks (TEXT) Table: Details…
So I see in psycopg 2, there is a set_client_encoding('UTF8') function. In the psycopg 3 documentation it reads: client_encoding is gone Here I create the connection: conn = psycopg.connect(conninfo, row_factory = dict_row, autocommit = autocommit, client_encoding="UTF8") But then when I…
There's no way in google cloud sql postgres to make a superuser. So I get: psql --version psql (PostgreSQL) 16.3 (Postgres.app) psql postgres://postgres:password@ip/db FATAL: permission denied to set parameter "log_min_messages" when I try and connect. I've set this flag to…
i have a project with 3 services 1-backend for golang project with groom db manager 2-db for postgres sql 3-redis for session manager i have this dockercompose file services: db: image: postgres:15.7 restart: always network_mode: bridge volumes: - ./db/table.sql:/docker-entrypoint-initdb.d/init.sql ports:…
I have a query writing problem. My table: -> table users_keyword_document document_id | users_keyword_id -------------+------------------ 65 | 1 65 | 2 66 | 1 66 | 3 I want to retrieve only the document with document_id 65 The search can…
Imagine you have the following table named city: market product cost A 1 54 A 2 62 A 3 38 B 1 12 B 2 12 B 3 5 I need the most expensive product for each market, i.e.: market…
I currently have a Sonatype Nexus instance running on an EC2 instance with the H2 database. I'm looking to migrate the database to PostgreSQL. Sonatype Nexus offers an in-built option only for the Pro edition which unfortunately I do not…