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
1 answer

Postgres import data- datetime variable out of range

I'm trying to use PgAdmin 4 to import some data from a csv file into a table. The following error is being returned for a column named "Event_Date" ERROR: date/time field value out of range: "26/04/2017 21:10:00" HINT: Perhaps you need a different…
natnay
  • 460
  • 1
  • 5
  • 24
0
votes
1 answer

PostgreSql - Cast to cidr during database migration

I'm french. So, sorry for my mistakes ! I'm doing a database migration on PostgreSql 9.6 via pgAdmin4 and in the first one there's a CHARACTER VARYING type field and in the other it's a CIDR type field. I use this command : INSERT INTO ip.cidr…
Unrillaz Ti'bob
  • 71
  • 1
  • 1
  • 7
0
votes
1 answer

cannot use multiple select queries in pgadmin4

Is it that pgadmin 4 does not support the execution of multiple select queries? I tried executing this query select cust, prod from sales; select * from sales it only showed me one table
JustCurious
  • 780
  • 1
  • 10
  • 29
0
votes
0 answers

Cannot connect to local postgres database via pgAdmin4 (Mac)

I have two databases running locally, I am able to connect to both via the psql command line, but when I attempt to connect to the second database, my unit test db, it throws a "Connection to server has been lost" error. I have no issues connecting…
pieman
  • 21
  • 3
0
votes
1 answer

How to execute query statements generated in pgAdmin4?

I have the following query which generates a list of ALTER TABLE statements in the 'Data Output' field in pgAdmin4. I can copy & paste them back into the query pane and execute them there. select 'ALTER TABLE ' || table_name || ' OWNER TO myuser;'…
Don
  • 3,876
  • 10
  • 47
  • 76
0
votes
2 answers

Launch PostgreSQL GUI

I have installed PostgreSQL v9.6 on Windows 7 using my user (PC-Admin), the problem is when I start Pgadmin4.exe the application shows that it is starting then freeze without showing the GUI , taking the following notes into consideration: it is…
Mhd H_Nahhas
  • 27
  • 1
  • 4
0
votes
0 answers

pgadmin 4 v 1.5.2 not starting in windows 8.1

I had installed pgadmin 4 - v1.5.2 on system with Windows 8.1 Enterprise 64bit Os. When I start pgadmin it's stuck with message - "Loading pgAdmin4 v1.5...". To troubleshoot I had made below changes to config_local.py. Disable upgrade Enable debug…
Arul
  • 143
  • 3
  • 12
0
votes
1 answer

Reading a column value from more than one table based on some condition - postgreSQL

I am trying to create a view for one of the tables I have. For one of the columns in the view, I am trying to read the value from the tables I have: Table A: id b_id c_id d_id 1 1 2 1 3 1 Table B: id …
julien carax
  • 323
  • 6
  • 22
0
votes
2 answers

Unable to connect to PostgreSQL on remote server via Pgadmin 4

I installed Ubuntu 14.04 on Azure recently. Have been trying to connect to PostgreSQL but the server refuses the connection. I checked and confirmed that it was online. I also tried changing the settings to trust on pg_hba.conf and I also edited the…
Ess Tee
  • 1
  • 3
0
votes
1 answer

Importing csv file into postgres db using pgadmin with special characters

I'm importing data from csv file into postgres db using pgadmin 4 Everything is ok but I get an issue when I try to import a file which contain some data like this “‘t Zand, Vlotbrug” “Dussen, `t Middeltje” as you can see, the data contains…
Norutan
  • 1,480
  • 2
  • 14
  • 27
0
votes
2 answers

Messed up pgAdmin 4 menu bar

I would like to know how to load the default setting for pgAdmin-4. I messed up with the menu bar and now I cannot see the tree view. I tried re-installing it but still loading the same setting. I posted a screenshot for reference. Any ideas?
fxmike007
  • 1
  • 1
  • 1
0
votes
0 answers

PostgreSQL Cannot see Data in View rows

I am learning how to use PostgreSQL and I have inserted data in my table but I cannot see the data when I click view rows. I get the error message below(2). (1)Here is the create Table Statement -- Table: "Test2 Schema"."Jobsearch" -- DROP TABLE…
John Tomasson
  • 65
  • 2
  • 11
0
votes
1 answer

How to alter a table and add in a date column which doesn't allow dates before a certain date in sql?

I need an sql query to alter a table to add in a date column, which is the part I know how to do. What I don't know how to do is specify that the dates in the column need to be after a certain date. My latest attempt: ALTER TABLE ADD…
Help pls
  • 15
  • 1
  • 7
0
votes
0 answers

SSH-Tunnel support workaround for pgAdmin4?

After installing Vagrant/VirtualBox and connecting to the database via pgAdmin 3 using ssh tunnel, I am warned that it is not compatible with pgAdmin 3. I can still connect but after some time pgAdmin will seemingly randomly shut down. pgAdmin 4…
Don
  • 3,876
  • 10
  • 47
  • 76
0
votes
1 answer

postgres (pgAdmin) database connection issue

I'm a new sql user (3 days) and I'm having some problems querying data from database tables I've created, whereas there is no problems querying the default 'postgres' database tables. My first thought was that it was a access/privilege problem, but…
LeeH
  • 55
  • 13
1 2 3
…
78 79