With Typeorm + NestJS + Postgres is there a way to update multiple records with varying conditions and varying values in a single query. Normally I could do awa
There is a request table in my database. Here is its structure Usually I created the entity with my hands, but this time I decided to generate it from the data
TL;DR: Is it OK to specify a schema in table_name_prefix? We have a large Rails application that is not quite a traditional multi-tenant app. We have a hundred
My current setup requires that the whole liquibase-migration is executed with a specific DB-role. I currently have the following changeSet on top of my script:
I need to run a query as cronjob and it is too slow to perform. It sums a value from a view table (data_time_series) for each pair of aks and ii and inserts a r
=# select row(0, 1) ; row ------- (0,1) (1 row) How to get 0 within the same query? I figured the below sort of working but is there any simple way? =# se
I have done server setup multiple times with the same settings but this time, I am seeing the error message. It is not even allowing to migrate the database. Sy
In my project, using Quarkus, Angular and PostgreSQL DB, when I run the backend & and the frontend in dev Mode, I can connect to the DB (which is postgreSQL
I have a search query that its parameters changes depending on the client input. await prisma.$queryRaw(`SELECT column FROM table ${condition ? `WHERE column =
Database newbie here. This is my query, I'm using Postgres 9.3.5: =# explain analyse SELECT SUM(actual_cost) as cost, SUM(total_items) as num_items, proces
What is the equivalent of SQLite's IFNULL() in Postgres? I have to following query (sqlite in Ruby): SELECT ifnull(max(code_id) + 1, 1) FROM configentries W
Let's say I have the following range in Excel named MyRange: This isn't a table by any means, it's more a collection of Variant values entered into cells. Exce
i have a dynamic list. list=['a','b','c','d' ..... ] so length may change i want to compare these list values in a query select * from student where name i
I want to setup logical replication between two postgresql 9.5 servers. I could make it work on two virtual pc-s but when I try to do it on our production machi
I want to use club position and check if preferred_position contain the string then return True/False value for each row. Club_position Preferred_position RM R
I want to create a TypeORM Postgres connection with Heroku using Typegraphql, but I receiving the following error message: 'createConnection' is deprecated.ts(6
I am trying to migrate a DB from sqlite to postgresql...so I typed: sudo -u postgres psql postgres=# ALTER USER postgres WITH PASSWORD 'newpassword'; and the
I found this related answer useful: Export "Create Aggregate" functions from PostgreSQL But how do I get the CREATE AGGREGATE statement without a GUI client (
I would like my query to return a result structured like this, where tags is an array of arrays or similar: id | name | tags 1 a [[1, "name1", "color1"
I am pulling data from an online database using SQL/postgresql queries and converting it into a Python dataframe using Pandas. I want to be able to change the d