I am trying to manually run a SQL script to create some tables and insert some data on my recently created Heroku instance, database is Postgres, when running I
My project is using SpringMVC, MyBatis, and PostgreSql. In postgres, I have 2 servers: sv1, sv2. I imported a table from sv2 into sv1 using: import foreign s
I have a simple Java application running in an openjdk Docker container that is executing on a FIPS enabled host system (on a Kubernetes clust
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(