Questions tagged [pgadmin-4]
pgAdmin is an open source management tool for Postgres. pgAdmin 4 is a completely new client, intended to replace the older pgAdmin III.
142
questions
0
votes
0
answers
20
views
pgAdmin 4: How can I change the default starting value of sequences?
I don't like sequences starting from 1 while vectors, arrays etc. start from 0. Having sequences start from 0 makes it easier to store the rows in a container easier.
Each time I create a table in ...
1
vote
0
answers
28
views
Ubuntu How to change the username PGAdmin tries to use to login
I uninstalled Postgresql and PGAdmin4 from ubuntu and installed them back but, now, when I open PGAdmin and click on servers/local, it requests for the password of a user no longer exists and there's ...
0
votes
0
answers
23
views
Groups for local users in pgadmin4 (web server mode)
I have a containerized setup of pgAdmin4 V8.5 in server mode running.
Does anyone know if I can create groups for local users in pgadmin4 in web server mode and set privileges for them?
Basic idea
To ...
-4
votes
1
answer
73
views
How can i write a sql statement to get customers who have rented at least one film from each category from dvdrental
How can i write a sql statement to get customers who have rented at least one film from each category, to Return customer_id, first_name and last_name. from dvdrental
0
votes
0
answers
158
views
Pgadmin4: Export/decrypt saved Passwords
Since we are migrating pgadmin from sqlite to a postgres Database, one of my main problems right now is to export the stored servers with their saved passwords.
The passwords are encrypted using the ...
0
votes
0
answers
229
views
Cannot edit data or delete row in table (pgAdmin)
I am new to pgAdmin and i want to delete a row in a table directly inside pgAdmin. ChatGPT tells me I should be able to do this, either by a query
DELETE FROM table_name
WHERE column_name = '...
1
vote
0
answers
190
views
Can not enter a new master password in pgadmin4 v5.7
I am working with two versions of pgAdmin4, v5.7 and v7.4. With v7.4 I don´t have any trouble with connecting to my local or remote servers, however with v5.7 I have encountered problem with logging. ...
-1
votes
1
answer
40
views
What are existing tables on a new PostegreSQL 15.1 installation?
I've just installed PostegreSql 15.1
Previous I installed and uninstalled it several times
After this last installation, if I try via PgAdmin to see "default" PostegreSql tables, the list is ...
0
votes
1
answer
456
views
Connecting to AWS RDS succeeds via terminal but fails in pgAdmin 4. Why?
I can establish an SSH tunnel using ssh -L 2222:<RDS-Endpoint>:5432 ec2-user@<EC2-IP> -i ~/.ssh/key.pem and then connect to my RDS using psql "host=localhost port=2222 user=postgres ...
0
votes
0
answers
1k
views
PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver
I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
0
votes
2
answers
428
views
PostgresDB - Updating a Table from a different Server
I have a Database on a server (external) that has multiple tables that I have a connection to.
I have created a select query that does various joins and that gives me the desired final view of this ...
0
votes
1
answer
697
views
Error when trying to view data in PGAdmin4, PostgreSQL10, on Ubuntu 22.04
I've installed PGadmin4 on my Ubuntu 22.04 system, with this repository :
https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main
PGAdmin4 runs, but if I want to see ...
1
vote
0
answers
472
views
Unable to Install PostGIS Extension for PostgreSQL 15 on Mac Book with M1 Chip and macOS Ventura 13.3.1
Issue: Unable to install PostGIS extension for PostgreSQL 15 on Mac Book with M1 chip and macOS Ventura 13.3.1.
Steps I have taken:
Installed PostgreSQL 15 using the terminal.
Installed PostGIS using ...
-2
votes
1
answer
153
views
Problem :simple query takes too long to complete (over 7 minutes) [closed]
CREATE OR REPLACE FUNCTION public.fn_question_3_3()
RETURNS TABLE(name character varying, surname character varying, person_t person_type)
AS
$$
DECLARE
pt person_type;
BEGIN
RETURN QUERY
...
0
votes
1
answer
1k
views
How to change query tool font and colors in PgAdmin 4?
In PgAdmin III, it is possible to change the font and colors for the query tool editor window in the options menu:
I can't find any similar settings in the preferences window for PgAdmin 4. How and ...