I have a table with a column with type double precision[] created like this: from sqlalchemy import Column, String, ARRAY mytablename= 'mytable' class creat
I have a docker-compose that brings up the psql database as below, currently I'm trying to connect to it with pgAdmin4 (not in a docker container) and be able t
Hi I'm working on a Spring Boot Project using PSQL. I have a model that is implemented pgcrypto like this, @ColumnTransformer( read = "pgp_sym_decrypt( ms
I am trying to save the List<byte[]> object in Postgres DB, but I am getting the below error. Caused by: java.lang.IllegalArgumentException: Value was not
pg_dump version 10.3 started adding the schema name explicitly to the table name. So what used to be INSERT INTO table (id) VALUES (1); Is now INSERT INTO p
I have some micro service (almost) system where each program has its own port. Moreover, not all ports in the system are available. For simplicity, I decided to
I have the following Data entity: @PrimaryGeneratedColumn() id: number @Column() dataA: string @Column() dataB: string @Column() dataC: number @Colum
Basically I just want a simple way of finding the most recent date in a table, saving it as a variable, and reusing that variable in the same query. Right now t
I'm using Diesel with PostgreSQL. I added my migrations, and they worked fine, outputting everything in the schema.rs file. Until I noticed that I was missing t
I have two tables exchange_rate (100 Thousand Rows) and paid_date_t (9 million rows) with below structure. "exchange_rate"
I am not able to login into my postgres databse deployed in docker. PFB my docker-compose.yml discountdb: image: postgres docker-compose.override.yml d
How do I use the knex db object inside other files? For Example my index.js const app = require("express")(); const cors = require("cors"); const bodyParser
I have some lines of SQL which will take a set of IDs from the same GROUP_ID that are not contiguous (ex. if some rows got deleted) and will make them contiguou
I have a Kubernetes cluster that I am trying to deploy different Helm Charts, when charts have no persistence everything works great. When the Helm charts use p
I am using Github Actions Service Container to start a postgres instance like so: name: Pull Request on: pull_request: branches: - main - sta
I am using typeorm in typescript project to connect to postresql 11. I have below query in sql which gives me expected results: select "customerUuid", array_agg
I'm migrating a query of Oracle pivot to PostgreSQL crosstab. create table(cntry numeric,week numeric,year numeric,days text,day text); insert into x_c values(
I have a table which stores users information(id, name, surname, address, email, etc). I don't want to use auto-increment function of the database. So, we don't
I have two postgres databases, one for prod and another for testing in "DATABASE_URI" and "TESTDATABASE_URI" respectively. The app seems to working perfectly, w
I am new to PostgreSQL and I need to import a set of csv files, but some of them weren't imported successfully. I got the same error with these files: ERROR: e