I have a table that looks like this: name val 1 1 2 2 3 1 4 2 5 2 6 10 For each row,
On PostgreSQL 13, I have a table define as such : create table my_table ( id serial8 primary key, title varchar(50), description varchar(512), frenc
I have Django application with postgresql on docker. I tried to insert data like this: import psycopg2 try: connection = psycopg2.connect(user="postgres",
I'm trying to add tens of thousands of Twitter profiles to a PostgreSQL database using the function below. The Twitter part works great - I get batches of 5000
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