I'm rying to setup a CMake project under windows 10 using PostgreSQL. When I try to find_package find_package(PostgreSQL REQUIRED) I get the following error
I'm trying to verify that my postgres pod is accessible via the service that I've just set up. As of now, I cannot verify this. What I'm able to do is to log
I've create a postgresql instance into my openshift origin v3. It's running correctly, however I don't quite figure out why I am not able to reach it remotely.
I'm using Postgres version 9.6.9 and attempting to use width_bucket() to generate a histogram with buckets consisting of equal widths. However, the query I'm us
Using PostgreSQL database for my attendance application. I have a table with IN and out times (hh:mm:ss.us format). When I subtract the times (OUT -IN) to ca
I have these 2 tables tasks and subtasks with these columns: Tasks id name description Subtasks id name description task_id I'm trying to do a query that would
I'm trying to create a simple demo with postgres on a local windows machine with docker desktop. This is my yaml docker compose file named img.yaml: version: '
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