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

Pgadmin server not contacted

I just installed PostgreSQL 13 on my windows 10 pc and when I opened pgadmin 4 I got this error please help me to solve this problem
Ayush Chugh
  • 5
  • 3
-1
votes
1 answer

PgAdmin Exporting text column to csv file

I have a table with 3 columns - type, name, and code. The code column contains the procedure/function source code. I have exported it to a csv file using Import/Export option in PgAdmin 4 v5, but the code column does not stick to a single cell in…
Mano
  • 601
  • 10
  • 32
-1
votes
1 answer

Cannot run Apache2 server in ubuntu

I've installed pgAdmin4 in Ubuntu 18.04 by doing: $ curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add $ sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" >…
Pedro Cris
  • 53
  • 1
  • 9
-1
votes
1 answer

Comparing time in text format in psql 12

SELECT * FROM lighting WHERE cast("time" as timestamp) BETWEEN '23:55:00'::timestamp AND now(); But I get the error as follows: ERROR: column "23:55:00::timestamp" does not exist LINE 3: WHERE cast("time" as timestamp) BETWEEN…
Echchama Nayak
  • 971
  • 3
  • 23
  • 44
-1
votes
2 answers

What means Configuring authentication for SERVER mode

I got postgresql and pgadmin4 with docker swarm on my ubuntu 18.04 server, but pgadmin gives me errors and after a while the application crashes and I can't enter postgres: this is the error PermissionError: [Errno 1] Operation not permitted:…
user5538351
  • 11
  • 4
-1
votes
1 answer

Launching pgAdmin v4 on a browser that is not the default one

I have pgAdmin v4 installed, my default browser is Firefox, but I would like to open pgAdmin as a standalone app on Chrome. I fixed that problem following the procedure described in various Stackoverflow answers such as Launch pgAdmin 4 as a…
Giorgio R
  • 85
  • 1
  • 9
-1
votes
1 answer

join tables based on partial string sql

I have two tables: regional imd The regional contains a location column with information about cities of UK. The imd table contains a column 'Name' which also includes the city names. I want to join both tables based on the location and Name but…
Sannia Nasir
  • 1
  • 2
-1
votes
3 answers

create a table based on other tables

I have 4 different tables: student: sid, name, gender grades: sid, grade address: postcode, sid, distance_to_school health_condition: sid, health_code Now I want to make a new table that contains all of the columns that I mentioned above. I…
SadSalad
  • 69
  • 2
  • 12
-1
votes
1 answer

How to insert values from a query to another table field?

I have a table below on my models called orders class Order(models.Model): customer = models.ForeignKey(Customer, null=True, on_delete= models.SET_NULL) product = models.ForeignKey(Product, null=True, on_delete= models.SET_NULL) …
kamcoder
  • 75
  • 7
-1
votes
2 answers

Not connected to the server - postgresql

I recently upgraded to postgresql 11.5. When I attempt to access my database i receive the error message "Not connected to the server or the connection to the server has been closed." It had been working previously in the older version (11.4). I…
rsarn
  • 1
  • 1
-1
votes
1 answer

Relation between postgres and pg-admin

can any one help me with this? How pg-admin is used with postgresql? How do they work together? I want to know the working and the realtion between the two.
Khan Mohammad
  • 1
  • 1
-1
votes
1 answer

Unable to import sql file in pgadmin4 on windows

I'm trying to import sql file in pgadmin4 using psql command in windows but it returns "The system cannot find the path specified." I tried to restore database by using pgadmin but it does not work. Please help me.
Prabina
  • 127
  • 8
-1
votes
1 answer

How do I create a column inside a table based on a query in sql?

I'm sure this is a very simple question. I have a table with a column that has a series '1' and '0'. I want to create two more columns. On column with only '1' and another with only '0'. I was able to get data based on this information with: SELECT…
Johntr3
  • 1
  • 1
-1
votes
2 answers

Connection remote Postgres server with ssh tunneling using pgAdmin4

I am using pgAdmin4 version 3.1 on macOS. Today I tried to connect my remote Postgres server with ssh tunneling. When my remote server ssh port is the default (22) then there is no any problem. pgAdmin can connect to the server by creating a ssh…
sancho
  • 598
  • 2
  • 8
  • 22
-1
votes
1 answer

query builder to postgresql like MS ACCESS

Sometime I use Query builder from MS ACCESS to create the query to PgAdmin. Is there any tool like MS ACCESS to build query to Postgresql? Tks.
A.Caruso
  • 1
  • 1
1 2 3
…
78 79