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
6
votes
3 answers

How to copy data from pgAdmin without double quotes around the values

I have the below query to convert geometry into GeoJSON format. select ST_ASGEOJSON(POLYGON_GEOMETRY) from "POC"."POLYGON_PLN"; output:…
Rupesh
  • 63
  • 1
  • 5
6
votes
1 answer

Pgadmin 4 pg_restore: [archiver] input file appears to be a text format dump. Please use psql

Hi I am using Postgres 11 and pgadmin 4.1. I have a SQL file i am trying to import in my newly created database in pgadmin 4. I know its a generalized error but I tried my best to resolve it, but not working for me. Here is the error: Here are a…
Maha Dev
  • 3,915
  • 2
  • 31
  • 50
6
votes
1 answer

PGAdmin - Why is DB Restriction (and Advanced Properties) Disabled?

I'm hoping to restrict the number of databases I see in the browser tree/heirachy since it's an AWS server with hundreds of DBs. Based on this answer I found how to do that. But I can't edit this field (DB Restriction). Click, double click, right…
Liam Hanninen
  • 1,525
  • 2
  • 19
  • 37
6
votes
1 answer

Extremely annoying cursor issue in pgadmin4 ver 3

After moving to pgadmin4 ver3 from the prior version I am no longer able to see my cursor when editing text in the query window. I can highlight text but If I move anywhere within the text line the cursor does not appear. It sometimes will appear…
Phil_in_Tx
  • 237
  • 2
  • 8
6
votes
1 answer

PgAdmin4 enable debugging

I am unable to enable debugging in pgAdmin4. I have performed the following: 1. checked $libdir 2. checked the locatin of plugin_debugger.dll 3. changed postgresql.conf and the database will not restart. Any suggestions what have I done wrong?
Judit
  • 114
  • 1
  • 3
  • 10
6
votes
1 answer

postgres pgagent job status

I have installed PostgreSQL 9.6 in win 10. Also installed pgAgent for job scheduling. I have create one job for batch file execute but it showing status 'r','i'. What is the meaning of status field. I have attached screenshot. image link1 image…
user619
  • 149
  • 2
  • 2
  • 13
6
votes
1 answer

Column does not exist, pgAdmin 4

INSERT INTO public."LeadCustomer"( "CustomerID", "FirstName", "Surname", "BillingAddress", "Email") VALUES ("12", "Lola", "Smith", "24 Cashmere Lane, Lancashire, LA4 6QT", "lolasmith@gmail.com"); ERROR: column "12" does not exist LINE 3: …
Dani Miller
  • 61
  • 1
  • 1
  • 2
6
votes
2 answers

SQL command to stop job in pgAdmin 4

I have a Postgres 9.6 installation on a developer pc and a restore seems to have failed. Even after reinstalling (remove Postgres and PgAdmin completely, incl. database and installed new version) the boxes are popping up (even though these tables do…
Beachwalker
  • 7,685
  • 6
  • 52
  • 94
5
votes
1 answer

PGAdmin can not view data, missing FROM-clause entry for table "rel"

I am using PgAdmin4 with version 7.4. From today suddenly I can not view table or rows and getting this error for all tables. missing FROM-clause entry for table "rel" LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid Getting…
mahfuj asif
  • 1,691
  • 1
  • 11
  • 32
5
votes
0 answers

Upgraded pgAdmin shows warning, not displaying Tables list, queries working without problem

I upgraded my local Postgresql test server to PostgreSQL15 today morning. Opening pgAdmin gave me a warning that some of the features may not work correctly because I have a server with version 9 added to pgAdmin. Steps done: Upgraded Postgresql…
Maya
  • 183
  • 1
  • 14
5
votes
0 answers

How to adjust the relationship line between tables when the position of tables are changed in pgAdmin4?

I created two tables and built a foreign key between them, now I want to reorganize position of the tables in ERD (pgAdmin4 - version 6.14). I'm try reorganize, but I cannot, see image-01: My expectation is to align relationship line between tables…
lucasjunioo
  • 51
  • 1
  • 1
  • 4
5
votes
0 answers

pgAdmin IV "'charmap' codec can't decode byte 0x8d in position 8773: character maps to "

I'm using pgAdmin IV (version 5.7) now because of my job, previously I only had used pgAdmin III. My problem is that I have already set the charset correctly with set client_encoding = 'Win1252'; and when I execute a select, this error still…
FMorschel
  • 799
  • 5
  • 18
5
votes
1 answer

Unable to install pgAdmin 4 in ubuntu 21.10

I am facing some issues when I tried to install pgAdmin4 in the latest ubuntu version 21.10. I have Installed the public key for the repository using following command sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key…
Afeesudheen
  • 936
  • 2
  • 12
  • 21
5
votes
6 answers

The repository 'https://apt.postgresql.org/pub/repos/apt trusty-pgdg Release' does not have a Release file

Linux Mint 20.2 I want to install PgAdmin4. Here OFFICIAL TUTORIAL https://www.pgadmin.org/download/pgadmin-4-apt/ Steps: sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add % Total % Received % Xferd Average…
Alexei
  • 14,350
  • 37
  • 121
  • 240
5
votes
4 answers

The pgAdmin 4 server could not be contacted

I've installed PostgreSQL 12, and pgAdmin 4. When I try to run pgAdmin 4 i get a fatal error "The pgAdmin 4 server could not be contacted". I've tried running it as administrator, deleting files at "C:\Users\User\AppData\Roaming\pgAdmin" and adding…
Michał Maciejewski
  • 53
  • 1
  • 1
  • 4
1 2 3
…
78 79