Stack Overflow
Stack Overflow

Questions tagged [pgadmin-4]

pgAdmin 4 is an Open Source administration and development GUI for PostgreSQL.

pgAdmin 4 is a complete rewrite of pgAdmin 3.

pgAdmin4 is cross platform (i.e., Linux, FreeBSD, Solaris, macOS and Windows) and supports PostgreSQL v9.2 and above.

It is available as separate download https://www.pgadmin.org/, but also included in PostgreSQL https://www.postgresql.org/.

1180 questions
22
votes
12 answers

PostgreSQL: What is meant by "please specify covering index name"

I wanted to edit the actions in a table. However I get the error message "Please specify covering index name." when I try to edit the FK. How do I fix this? The table consists of only two columns: The foreign keys: category FK:
NullOrNotNull
  • 365
  • 1
  • 4
  • 11
20
votes
3 answers

Why am I getting a permission denied error for schema public on pgAdmin 4?

I'm trying to view the raw data from the AACT Database in pgAdmin 4. I'm on a Mac computer. When I just try to view the first 100 rows from the 'complete_oncology' table, I get the below error: ERROR: permission denied for schema public LINE 1:…
cpburke94
  • 467
  • 1
  • 6
  • 13
19
votes
6 answers

pgadmin 4, cannot find "edit data"

I read the Q/A "How to insert a row in postgreSQL pgAdmin?" from enter link description here , but it's for pgAdmin 3. I just installed postgreSQL 9.6.2 with pgAdmin 4, but could not find the option shown in pgAdmin 3, which you can click to have an…
Carol Liu
  • 335
  • 1
  • 2
  • 5
18
votes
2 answers

Activate pgAdmin 4 desktop mode

I have downloaded PostgreSQL 10.4 and when I launch it pgAdmin4 opens in a web browser. I want to use the desktop mode and I don't know how to do it on Windows 7. Any help ?
McAlixter
  • 233
  • 1
  • 2
  • 6
18
votes
14 answers

PGAdmin: Not connected to the server or the connection to the server has been closed

i got this problem with postgreSQL, when i do a simple query of anything (CRUD), sometimes it works and almost always shows this message: Not connected to the server or the connection to the server has been closed. I don't know how to solve it and…
Jorge
  • 261
  • 1
  • 2
  • 12
17
votes
2 answers

Select does not return values Postgres-11.4

I am using pgAdmin-4 and created a database with a single table, but select returns an error message: 'table oid' I'm using a normal select query. SELECT * FROM escola This happens with PostgreSQL 11.4.
Maykon Morais
  • 171
  • 1
  • 6
17
votes
7 answers

Error trying to run pgAdmin4

I've installed postgresql 9.6 (using suggested linux installer) which comes with pgAdmin4, but getting a few errors. First, I had to change the folder name from "pgAdmin 4" (note the extra space) to "pgAdmin4" to avoid "file not found error". Then I…
Elad Tabak
  • 2,317
  • 4
  • 23
  • 33
16
votes
7 answers

Why pgAdmin 4 is so slow?

pgAdmin 4 GUI for postgreSQL is very slow. It takes too much time to even expand a server tree or a database tree. They each took almost 30 seconds to expand. It also hangs while creating a new database or table. Even after loading it took more than…
Karthik
  • 175
  • 1
  • 1
  • 11
16
votes
4 answers

How to import a schema sql file using pgadmin 4?

Is it possible? If so how? I can only find solution for pgadmin 3 which doesn't work for me.
Chris Stryczynski
  • 30,145
  • 48
  • 175
  • 286
16
votes
5 answers

How to access remotely PgAdmin4?

I Try access pgAdmin4 via browser instaled in another Notebook with Linux Ubuntu 16.04 in the same network in my house, but not access. In localhost... Ok But REMOTELY... DOES NOT ACCESS
Davi Menezes
  • 507
  • 1
  • 5
  • 10
15
votes
4 answers

Cannot Save New Records in PgAdmin4- "SAVE" Icon Grayed Out

I'm saving new record entries in PgAdmin4 database, but cannot saved the new records because the "SAVE" icon is grayed out. What should I do to enable the SAVE function? I'm just learning the PostgreSQL database and PgAdmin4 on the creation of…
Satoru Sotoyama
  • 151
  • 1
  • 3
15
votes
1 answer

"Create database if not exists" in postgres

I am new to postgreSQL and I am trying to create a schema file which will contain all the scripts required to create the database and required tables. The way I used to do this for SQl server was to check if the database exists and then run the…
Sugan88
  • 313
  • 1
  • 4
  • 21
14
votes
7 answers

Loading pgAdmin 4 v7.4... while opening pgAdmin

I have installed postgreSQL 14 on windows 10 and after opening pgAdmin this inscription "Loading pdAdmin4..." lasts forever I tried to change version of postgres to 15, but it didn't help I tried to add Content Type=text/javascript and…
Yana Aziamblouskaya
  • 151
  • 1
  • 1
  • 5
14
votes
4 answers

PostgreSql: 'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte

I recently installed PostgreSql and I am trying to create a new database. Unfortunetly I got and error while creating the database: "'utf8' codec can't decode byte 0xe9 in position 42: invalid continuation byte" What is the problem exactly thank…
narcisse
  • 401
  • 4
  • 8
  • 15
13
votes
2 answers

PGAdmin creates new random volume with each "docker-compose up"

Each time I run the following command: > docker-compose up -d ... in a directory where I have the following docker-compose.yaml file, I get a new, randomly named volume. docker-compose.yaml: version: '3.7' services: pgadmin: restart:…
MalcLear
  • 1,124
  • 1
  • 10
  • 21
1 2
3
…
78 79