Environment: Postgresql 13.x (dockerized) I was trying to test the DR setup for PostgreSQL nodes. pg_basebackup and wal_files archive was taken from the standby
Given a year and a quarter, a procedure should INSERT values into table tb_quarter, which is empty and have this structure: CREATE TABLE erp.tb_quarter (
PostgreSQL 13 The goal is to rename all src keys in the photos array to image. I have a table plans which has a column json with a simplified structure similar
I use PostgreSQL 13.3 I'm trying to think how I can make include/exclude in query at the same time I have include_system_ids [1,5] and exclude_system_ids [3] Th
I have a table which looks like this: ID money_earned days_since_start 1 1000 1 1 2000 2 1 3000 4 1 2000 5 2 1000 1 2 100 3 I want that rows, without a days_s
I want to import a large csv file without creating table before for that csv file into postgresql. While searching on stackoverflow, one of th
I've had a few project which is using this same database and entities. How to reuse entities across all of this projects? I don't want to copy all *.entity.ts f
I want to create a python function that takes a start date and end date as arguments. I want the dates passed to the function to be the start date and end date
I am trying to define two roles in Hasura: role_1: In my_table, can update: column_A and column_B role_2: In my_table, can update: column_C I want an end user t
How to configure a PSQL v11.4 user that is not the superuser and does not own the database. This user should have full access to create SQL objects and drop the
I have a table which looks like this: ID money_earned days_since_start 1 1000 1 1 2000 2 1 3000 4 1 2000 5 2 1000 1 2 100 3 I want that rows, without a days_s
I have an existing Hasura instance that uses Postgres 12 and Hasura 2.2.0. It has a schema called hauth_catalog and in that schema there is a table called users
Is there a efficient way to check if the Postgres backups (for managed services like RDS and Cloudsql) are not corrupted? Currently one of the ways we are imple
I want the log the execution message of a running stored procedure into a table in postgress --example: create or replace procedure ccc () language sql as $$ in
I a rails app running on my local environment using postgresql. This morning I spun up a new one and after install the pg gem, etc. I am running into the follow
EDIT : I think I was not clear, I am sorry for that : I have a column with bytea data. This column, when I apply encode(column,'escape') to it, I got text in th
I have a db where a foreign key references my primary key, Ill like to select all rows where the foreign key is NULL and then add rows with a foreign key as nes
I am building a Node JS Web application. I am using Postgres SQL and Sequelize for the database. I have the docker-compose.yaml with the following content.
I am using postgres DB and i have table with two column name and sal . name Sal Raunak 10000 Raunak 5000 Rahul 500 Raunak 300
In an app that I am currently developing users are allowed to locations identified, amongst other things by their latitude/longitude coordinates. The location e