I've been trying to solve this one all week, help very much appreciated. I have various schemas in a postgres db and I would like to be able to map to them fro
I cannot figure out how I can copy a remote server file as a CSV file on my local machine (windows). I have tried \copy mytable TO 'C:/pg/mytable.csv' CSV DELIM
I'm getting bad request code every time i try to send data query in graphql, and I can't figure if the problem from the resolver or from the input, below is th
I am following this post to enable ssl on Postgres 14 for logical replication. Then try to make connection on client: CREATE SUBSCRIPTION my-sub CONNECTION 'hos
I am following this post to enable ssl on Postgres 14 for logical replication. Then try to make connection on client: CREATE SUBSCRIPTION my-sub CONNECTION 'hos
While starting keycloak server on docker, I am getting this error: "You need local access to create the initial admin user". But running it locally, it's workin
I have 3 entities: User id: Int name: String Room id: Int name: String RoomUser id: Int room_id: Int (Reference on Room.id) user_id: Int (Reference on User.i
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"