I've been trying to insert a case statement into my create function statement and haven't had any luck. Just a heads up I am using pgadmin and postgresql. I have a table with rental movie titles, along with an integer…
I have downloaded postgreSQL version 15 and when I started the download the drivers, half of the drivers were not installed properly and then when I opened pgAdmin, it is stuck and not running further. What should I do? Please…
First, I was having pgAdmin fatal error, the application could not be contacted. so I uninstalled pgAdmin and reinstalled it. Now, when I write queries, PostgreSQL says "Connection to pgAdmin server has been lost". Then, I logged out and into…
First Attempt - CREATE FUNCTION rental_quarter (rental_date TIMESTAMP) RETURNS VARCHAR(7) BEGIN IF MONTH(rental_date) BETWEEN 1 AND 3 THEN RETURN YEAR(rental_date)+ ”Q1”; ELSE IF MONTH(rental_date) BETWEEN 4 AND 6 THEN RETURN YEAR(rental_date)+ ”Q2” ; ELSE IF MONTH(rental_date) BETWEEN 7 AND 9…
According to the 43.6.8. Trapping Errors topic in this Postgres Documentation, the correct syntax for handling exceptions is: BEGIN; -- SQL Statement EXCEPTION WHEN Others THEN -- Exception Handling Logic END; This is while when I use this syntax in…
I want to stop postgres server 13 since I installed postgres 15. I look for a stop server button in pgadmin but it looks like that this kind of a button does not exist. For such a simple functionality, I…
I have an api in spring boot and I decided to create a model order, but I found some database errors and I decided to enter my pg admin and delete all the tables and start over, but now when…
I have a dump from an SQL database, it is a .sql file. I tried restoring it in pgAdmin but I get an error: pg_restore: error: input file appears to be a text format dump. Please use psql. Then I…
Is there any way so that I use Apache AGE extension in pgAdmin ?
I am trying to connect to a Postgres instance running in a Docker container. In the docker-compose file, the postgres service looks like this: flask-api-postgres: container_name: flask-api-postgres image: postgres:13.4-alpine env_file: - dev.env ports: - "5433:5433" networks: flask-network: With docker inspect…