First time dealing with xpath and XML data. I have below xpath query that I got through some Stack Overflow answers. Below, I want to extract all the column nam
According to the postgress documentation a collation can be created to ignore cases during comparison operations. CREATE COLLATION IF NOT EXISTS case_insensitiv
I'm developing a high load server application using C++ and libpq (libpqxx is very unstable). I use async queries in threads to improve performance. But I've di
I am having a fun issue trying to get TypeOrm to work in my nestjs project. I have the below code to configure my project, yes everything loads, and yes I am ab
Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT
Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT
How to get the dv/dt of the below table in psql Concept is linear regression - but to determine the slope is the what I am facing issue with. voltage || time
I have a file in my TEMP directory on a windows server echo %TEMP% C:\Users\BOB\AppData\Local\Temp\2 Below command to insert file to table: psql -d BOBDB01 -c
BEGIN; SET search_path TO test; CREATE USER regress_view_user1; CREATE USER regress_view_user2; GRANT CREATE, usage ON SCHEMA test TO regress_view_user1; GRANT
I have a simple Django project with a PostgreSQL backend and I can't seem to get rid of the Django security vulnerabilities warning signs on my terminal. Settin
There are 163 tables, and I want to add two columns in all. And columns should be added from the front. Please tell me how to do it on postgreSQL This is a tabl
I am running docker-compose in Github-Action. docker-compose.yml has following service definition for postgres postgres: container_name: postgres imag
I'm trying to deploy a simple Rails app in heroku but I'm getting this message in the heroku logs: PG::UndefinedTable: ERROR: relation "entries" does not exist
I have a (dynamically generated) file that includes a lot of SQL Statements that contain only data definition. Usually, I run the whole script as a single trans
I need to set the default DB schema for a Django project, so that all tables of all apps (including 3rd party apps) store their tables in the configured Postgre
I am trying to create a json object from my query using json_build_object as follows: Select json_agg(json_build_object('first_name',first_name,
I am creating a database & working on CRUD functions. I've run into a problem with the Delete functionality. I have two tables, connected in a many-to-many
The following code: SELECT ets.event_id, ets.event_date, dtn.don_date, dtn.don_date - ets.event_date AS date_diff FROM events ets, donation dtn GROUP BY ets.eve
I'm using DbUp to deploy to a PostgreSQL-14 database. When I try to create a function or procedure using SQL-language syntax, DbUp throws an Npgsql.PostgresExce
I'm using DbUp to deploy to a PostgreSQL-14 database. When I try to create a function or procedure using SQL-language syntax, DbUp throws an Npgsql.PostgresExce