I followed this guide in order to upgrade the plan for postgres: https://devcenter.heroku.com/articles/updating-heroku-postgres-databases#updating-with-addons-u
create index if not exists department_index on department using btree (department_id); How can I create a Liquibase changeset for the above Postgresql? I h
I am using PostgreSQL 9.4 and I have a requirement to have an 'addresses' array which contains closed JSON objects for different types of address (residential a
Am new to Postgres. Anyone can tell how to have it work? What I want to do is to write Pandas datataframe to PostgreSQL database. I have already created a datab
I'm trying to load a large dataset (25 GB) into a Postgres table. The command below works, but it takes 2.5 hours and fully utilizes 3-4 cores on the machine th
I can in Prisma create columns without data, without time? my model at the moment: model modelName { id Int @id @default(autoincrement()) creat
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