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
2 answers

Unable to use SET OF record or return table(col1,[col2]) return type in pgadmin 4 version 2?

Basically i want to split the string based on the delimiter for example :- "this,is,foo" should return this is foo i.e; without the comma into separate records . i am trying to use pgadmin 4 version 2. this is my sample code below that i want in…
Abdul Gaffar
  • 1
  • 7
0
votes
0 answers

Procedure dialog not available in pgadmin4 version 2.0 in postgresql?

I am new to postgresql.I would like to convert stored Procedures and functions from MS SQL server. However in the Pgadmin client , the procedure dialog is not available and Function dailog behaves more or less like procedure? So Functions and…
Abdul Gaffar
  • 1
  • 7
0
votes
1 answer

Copy only constraint Keys from one database to another in pgAdmin

I have two servers (and two databases each one from a server on pgAdmin): The first server is for testing and the second one is the real server that the client will work on it. The two databases have same tables: 9 tables on the first one and the…
Mamba
  • 11
  • 5
0
votes
1 answer

PostgreSQL pgAdmin4 issue "The application server could not be contacted" on Mac

I have installed pgAdmin4 and it was working fine until I tried to install the newer version (I upgraded from v2.0 to v2.1). Since then I just keep getting the same output.
DonatB98
  • 1
0
votes
2 answers

Pgadmin connectivity issue with application server

I am using pgadmin 4.2.0 but when I open it to use, it shows the following error The application server could not be contacted. I installed and uninstalled the Postgres and pgadmin using brew many times but facing the same issue. Thanks in…
aishazafar
  • 1,024
  • 3
  • 15
  • 35
0
votes
0 answers

Facing issue to add new server in pgadmin4

I am new to Postgres and pgadmin4. I am trying to add a new server in pgadmin4 but I get the following error Unable to connect to server: FATAL: role "postgres" does not exist I have followed different methods to create role and user using psql…
aishazafar
  • 1,024
  • 3
  • 15
  • 35
0
votes
1 answer

Sql command to select more than one option in the table

I am working on a database in a geoprocessing software and have encountered some problems. It was necessary to create an extra layer in this database and I also decided to try to create it. Using the pgAdmin 4 software, PostgreSQL 10.1 and postgis…
MPJr
  • 1
  • 1
0
votes
2 answers

POSTGIS "ST_Contains" returns a empty query

I have imported two shape-files using QGIS into pgAdmin 4 (PostgreSQL), I use the PostGIS extension to be able to access spatial commands. I want to check all the POIS (points) that are included in the Gemeinden (multipolygon) table. To accomplish…
S. Njegoš
  • 1
  • 4
0
votes
1 answer

Pgadmin - Site can't be reached error

I am trying to set up pgadmin on ubuntu 16.04 (python, nginx), the steps are detailed below and I get a success message in the url to visit localhost:5050. I am thinking that I may have to specify the url somewhere but am not sure where to do this.…
David
  • 5,897
  • 3
  • 24
  • 43
0
votes
1 answer

pgAdmin4: need to restore database every time I run a query - how to fix this error?

I am a Mac OS user and I am using .tar file for my database source on pgAdmin 4. I discovered that every time I run a query, the data gets lost, and I need to restore the data before I execute the next query. For example, After executing: SELECT *…
jschnieder
  • 191
  • 1
  • 8
0
votes
1 answer

pgadmin, postgres and gogole cloud connection time out

I followed this tutorial. I managed to set up everything and do exactly as it was mentioned in the tutorial. But when I tried to connect to it using PGADMIN 4, i get connection time and out and I was never able to fix it. then I found this link,…
S. N
  • 3,456
  • 12
  • 42
  • 65
0
votes
1 answer

pgadmin4- missing csv option

I have problem. After upgrade my server I have too change pgAdmin to version 4 v2.0, and now I can't change the separator ext. I don't have option to change csv. My options : In manual they have option to change csv. Do you have any idea ?
Blurope
  • 3
  • 3
0
votes
0 answers

How to prevent system columns generated by default in PostgreSQL

Every time when I create a table in pgadmin 4. Systems columns(tableoid, oid, xmix,xmax, cmin,cmax) are generated by default. When i import a CSV file using pgadmin4 GUI it throws an error since I don't have those columns in CSV file. I have to…
Ghatwar
  • 1
  • 4
0
votes
1 answer

create sequence on pydev for postgres database

I am trying to generate random numbers from 90001 to 90150 (increments of one) under a column "GameID" and have it generated in the games table. What should I do? I heard a sequence might work but I am not sure how this would work. Any…
S AM
  • 31
  • 8
0
votes
1 answer

detailed guide for pgadmin deployment - Windows 7

I am an absolute new to postgresql, pgadmin and all it's tools. And with no python knowledge. I need to deploy pgadmin in as a web application on windows 7 os. I have been trying the pgadmin's documentation from the official site , with no results.…
Galilo Galilo
  • 519
  • 5
  • 22
1 2 3
…
78 79