I cloned a project that I want to modify and experiment with, and I have all the necessary credentials. However, I'm encountering issues while following the steps outlined in the ReadMe.md file since I cloned it: Clone the project. Create…
Can anyone help me please with this? what I run: docker run --name pgres --rm -e POSTGRES_USER=uzer -e POSTGRES_PASSWORD=1234 -e POSTGRES_DB=sample_db -p 5432:5432 postgres:14.1 but I cannot connect to that: even Nothing happens in the log: waiting for server to…
Im having this error when trying to connect to the database: [auth][cause]: error: password authentication failed for user "user" But i can connect to pgadmin normaly with the same credentials so I dont undertand whats going on. docker-compose.yaml services: postgres:…
I have two tables. table 1 Column A Column B rgz 1 dry 1 vgy 2 chy 3 pom 2 table 2 Column C Column D tuv 10 tuv 11 chx 22 lmn 34 I want the following result shown…
When I try to copy a CSV file with pgAdmin or just COPY command it shows me this error ERROR: nieprawidłowa składnia wejścia dla typu integer: "1,"A Dijiang","M",24,180,80,"China","CHN","1992 Summer","1992","Summer","Barcelona","Basketball","Basketball Men's Basketball",NA" CONTEXT: COPY olympics_history, line 2, column ID: "1,"A Dijiang","M",24,180,80,"China","CHN","1992…
I tried to create a 1-to-1 relationship in PostgreSQL but when i check the ERD it looks like a 1-to-many relationship. this is my SQL script: CREATE TABLE capital ( id SERIAL PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE country…
I think this may be my first time posting on Stack Overflow instead of just browsing for already-answered questions. I am not an avid html user and I am trying to update our splash page for our web app through…
I'm trying to deploy my postgresql v16 database to Azure via pgadmin v4.83. I start the Register -> Deploy Cloud Instance wizard and enter my tenantid and then press the "Click here to Authenticate yourself to Microsoft Azure" button. After…
I want to add this query to a column in my table.I am using pgadmin select customer_id, count(*) from summary group by customer_id order by customer_id asc I got as far as ALTER TABLE summary add sum_of_rentals INT UPDATE SUMMARY…
I am seeing a connection error when i try to read data from postgressql in my jupyter notebook. The error suggests: Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname or an existing connection: dict_keys([]) As far as i can see…