Table flights: ID Path 1 NZ:EU 2 JP:CA SELECT path FROM flights WHERE path ILIKE '%' || 'jpca' || '%' Above query isn't working, it needs to retu
I am using typeorm with postgresql. I want my auto incremented primary key column to start from specific initial value instead of 1. Is there any solution in ty
I have data in my timescale database. If we only look at the "time", everything is fine. But if we look at the "id" we can see that 152 and 153 numbers didn't s
There are two tables, one is called "user_preference" that contains all users: id | firstname | lastname | email | And "match" which combines users with meetu
I am using the code below to create a function with variables that updates a jsonb column with a json object or create it if it doesn't exist - With help from
I have a query which returns next table with name first_table: Name ID First 1 Second 2 And I need to join another table named second_table: ID ParentID 22 1
I have a table with a starting time, finishing time and delivery columns. The starting and finishing times are of the timestamp without time zone data type (YYY
I'm using StreamSets and will soon need to load data from fixed length file and packed decimal (cobol comp-3) to insert into Postgres to regular number numeric(
I am using pg_sym_decrypt/encrypt to decrypt/encrypt some of the fields in my table. Decryption happens on select in a separate EntityComputed view that has a o
Thanks for reading my post. I wanna know, what is the difference between length (1-256) and (0-256) in sql and how to store them in database?. I was asked to de
I’m using Jhipster (Gradle + React) for one of my project, and recently, I want to add Multi-tenancy support to the whole application (tenant will be the
The below query is getting locked by executing through perl ALTER TABLE base_table DETACH PARTITION part_table; By using this query select pid,state,
The objective of my application is to create a copy of documents and insert them into the database for each annotator, for example, let's say the master user ha
I hope anyone can tell me what I am doing wrong here. I have upgraded an Azure Postgres PaaS database from version 10 to 11. I've just followed the Microsoft gu
I'm trying to insert data into a 'users' table inside a postgresql database using the 'pg' NPM module. But when I make a POST request, the transaction executes
Technologies I use: nestjs -> for backend prisma -> for orm postgresql -> database I'm trying to run these technologies using Docker but I'm running in
What I'm trying to do in this case is to get the ''most future'' record of a Bills table and get all the record prior 13 months from that last record, so what I
I am new to Rust and I am using the Postgres crate. I am trying to create a wrapper around the PostgreSQL client, and I have defined this Struct: pub struct Pos
I'm trying to figure out what is causing the Aurora RDS Postgres database to deteriorate in terms of performance over time. I have a quite big table in a multi
I have a database of orders and each order has a time_slot (of type TIME). select id, time_slot from orders limit 5; 10 | 13:00:00 11 | 12:00:00 13 | 11:00: