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
0
votes
0 answers

Can't query data from my postgres database in Qt

I am very new to sql (3 days) and im using pgAdmin. Within pgAdmin, I can query any data from any availabe database's as normal, but from Qt after connecting successfully, I can only query data from the default database 'postgres' that I created a…
LeeH
  • 55
  • 13
0
votes
2 answers

Not able to view "Process Watcher" window in pgAdmin 4?

I have isntalled pgAdmin 4 and i am trying to import the csv file into a table.I have followed all the steps mentioned in the document. https://www.pgadmin.org/docs4/dev/import_export_data.html Once I click on OK button at the end of the importing…
Vishwa
  • 15
  • 2
  • 5
0
votes
1 answer

Update instead inserting same primary key when import using copy query to postgresql using pgadmin4

As the title say, i have table food with field food_id(PK) and food_name. I already have this data on table food_id|food_name ----------------- 0000001|food1 0000002|food2 0000003|food3 and on my…
Alexander Chandra
  • 587
  • 2
  • 9
  • 23
0
votes
2 answers

pgadmin 4 Mac restore job is created but not working

Whenever I try to restore a tar file to my database pgadmin 4 says restore job created but it never executes. I only see the restore job created dialog. After a refresh nothing changes. How can this be fixed? They do not support apparently pgadmin 3…
Gido ten Cate
  • 21
  • 2
  • 6
0
votes
1 answer

pgadmin 4: Exporting .tar file

I am trying to use pgAdmin 4 on my personal laptop (Windows operating system with PostgreSQL 9.6) to export a database as a .tar file. I had issues importing csv through the Import/Export tool as well, and could only import successfully when doing…
EntryLevelR
  • 273
  • 4
  • 16
0
votes
2 answers

PostgreSQL 9.6 with pgAdmin 4 - numeric data type

I have columns with numeric(5,2) data type. When the actual data is 1.25, it displays correctly as 1.25. When the actual data is 1.00, it displays as 1. Can anyone tell me why? Is there something that I need to set to have it so the two decimal…
Katydid
  • 331
  • 1
  • 2
  • 7
0
votes
1 answer

pgadmin 4 maintenance job creation failed

I just setup postgresql 9.6 with pgadmin 4. I have a database i am trying to run maintenance on but get the error maintenance job creation failed. I have the postgres binary path set to the following: Preference settings Error when I try to run any…
its30
  • 253
  • 3
  • 17
0
votes
1 answer

Accessing an external remote postgres database using pgadmin4 from a local machine produce password authentication fail

I am trying to connecting to a remote database with pgadmin4 using putty to portforward so I can connect to a local database on a remote server. This works normally like a charme. I switched computer and set up the database setting and putty the…
blackgis
  • 161
  • 1
  • 1
  • 8
0
votes
1 answer

Postgres dialect is not working in sequelize

Running my Express project on a Windows 10 machine with pgAdmin4. In sequelize/config.json file with postgres dialect, Sequelize gives some error. "development": { "username": "root", "password": null, "database":…
mhasan
  • 15
  • 4
0
votes
3 answers

Timestamp functions not returning time

I'm using Postgresql 9.6 and pgAdmin 4. Fresh install on both Windows and Mac, happens on both. I need to store the current time and date. None of my timestamp functions are returning times. Time and Date work fine SELECT CURRENT_DATE Output:…
MercilessMaverick
  • 257
  • 2
  • 12
-1
votes
0 answers

I'm drawing ERD diagrams in PGAdmin4. I can draw one to many relationship and a many to many relationship. But cannot do zero to many

I want to draw different relationships between tables outside of 1 to many and many to many. There are no tutorials or evidence of it anywhere. Where is zero to many or zero or 1 to many or indeed 1 and only 1. I am now writing text to fulfill the…
Elliot Fern
  • 1
-1
votes
0 answers

Extract some data from a table using SQL and functions like subsring() , strpos()

I am beginner in SQL, please help me... I have a table like this tblMain tagid tagname category 37286 A sas device 56789 A Equipment 28676 B sas device 46099 B Equipment 34596 C sas…
Hamed Mtd
  • 1
  • 1
-1
votes
1 answer

pgAdmin 4 server could not be contacted on WINDOWS 11

I'm having what I've found to be a very common problem when installing Postgresql 15 and pgAdmin4. I am trying to install it on windows 11, all the solutions I found are for windows 10 and are not applicable to windows 11. Most of the time they…
FStabi
  • 7
  • 1
-1
votes
3 answers

I cannot create a new server in my pgAdmin 4

I want to create a server in pgAdmin 4 but it's not working. enter image description here should actually work like this. enter image description here I'm a Linux Ubuntu 22.04 user. I tried create a server, but it didn't work.
Javohir coder
  • 1
  • 2
-1
votes
2 answers

How to stop posgresql server using pgadmin?

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 may have missed something. What do I think…
yılmaz
  • 365
  • 1
  • 14
1 2 3
…
78 79