I´m doing an Spotify clone and I´m trying to add a song to a playlist but my query doesn't work, until this point, everything was good following the
I am using Postgres as a service in my docker-compose file. I want logging to log file to be enabled when I do docker-compose up. One way to enable logging is b
I have a PostgreSQL database with Sequelize ORM and I want to listen for new entries. How should I do? Should I use Sequelize afterCreate hook? Can someone help
Before, I had the following table schema. CREATE TABLE cities ( "city_id" BIGSERIAL PRIMARY KEY, "city_name" TEXT NOT NULL UNIQUE, "employees_names"
I've googled for it, both couldn't find an answer. How can I list tables used by materialized view (must not use the information_schema views) in PostgreSQL? Th
I try to pass argument $1 to jsonpath-expression: SELECT 1 FROM %s.orders AS O WHERE order_info @? '$.items[*] ? (@.ProductID == $1)' but it doesn't work. P
I have an app that spikes postgresql queries at morning 70% CPU usage, and has very few the rest of the day less than 20% usage. I want this machine to autoscal
We have: Postgres Database Photo: import {Entity, PrimaryGeneratedColumn, Column, ManyToOne} from "typeorm"; import {User} from "./User"; @Entity() export clas
I want to run my app on my local machine within Docker. I don't want to optimize the size of my docker app or build it for production now. Docker builds my back
If the preparedStatement sql is fixed, how can I do the insert? table schema create table if not exists ttqs_a (b bit(1)); code try(PreparedStatement ps = conn
FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.1111.lock": Permission denied psql: could not connect to server: Connection refused Is
I have a Laravel 5.8 app. It works with a Postgres Database encoded with UTF8. I have a query for my users table, so i made my query as: $users = User::where
So I have a many-to-many relationship with Sequelize. This code gives me an array of all the categories associated with the Post. It works to get this data. How
Postgres logical replication initial synchronization is very slow process, especially if original database is quite big. I am wondering if it possible to start
In a Postgres 12 database, I have multiple queries (SELECT, UPDATE, ...) in a function that all together take about 20 minutes to complete. I have a check at th
To prepare for our Postgres to Postgres migration we have configured a DMS task and a target DB with migrations pre applied. We tested DMS and a cutover to our
I searched a lot and there are several questions like this however most of them do not have any answer or are not relevant to me. I'm using TypeORM(v0.2.45) wit
Is it possible to replicate a specific subset of data (certain schema,dbs') to a readonly copy of Azure postgres flexible server. Thanks Brian
I am trying to import data from a csv into postgres. I have tried the following and got the following errors: Copy TA_Files FROM 'C:\Users\ABla47\Documents\TA
I need to create a function that returns the string 'fall' or 'spring' depending on the month of the year. If the function was named getterm and took no paramet