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

ERROR: missing FROM-clause entry for table "dailysteps"

I am trying to inner join two copies of the table ActivtiyDay so I was assuming I could go ahead and join on these columns. The syntax that I am trying to use: SELECT ds.id, ds.ActivityDay, ds.StepTotal, dc.id, dc.ActivityDay, dc.Calories FROM…
Brandon Schultz
  • 1
  • 1
-1
votes
1 answer

How to connect pgadmin with google cloud postgres with ssl certificates

I am trying to connect to google cloud's postgres with ssl certificates. I have pgadmin application locally. I tried connecting by setting my ip addess in allow netwroks and it worked. But, If I emove that settinging and tried with SSL certificates…
saiyan
  • 512
  • 6
  • 21
-1
votes
1 answer

What are the differentiation between \l vs \d in postgresql?

And I want to know the details about template0 and template1 database
Vaitheeswaran
  • 87
  • 1
  • 2
  • 13
-1
votes
1 answer

How to put strings separated by a ; in different columns

So I am trying to put two strings in different columns but it doesn't work with Substring because I use string_agg So I am trying with SUBSTRING but I don't know how SELECT name, SUBSTRING(string_agg(lastname, ','),0) as last,…
GJO
  • 11
  • 5
-1
votes
1 answer

Postgres: Query the server name, IP address and the name of the instances running on the server

Is it possible to query the name and the IP address of a Postgres server (where the Postgres DBMS is running) (not the hostname or host IP address). Also, I was looking for a query to get the name of each instance running on the server. . I could…
alaa
  • 1
  • 2
-1
votes
1 answer

PG::UndefinedFunction: ERROR: function count(bigint, integer) does not exist in rails console

I have two models Product and Order have a relation between them belongs to product and has_many orders. #app/models/product.rb class Product < ApplicationRecord has_many :orders, dependent: :destroy end #app/models/order.rb class Order <…
Rahul Gupta
  • 53
  • 1
  • 1
  • 12
-1
votes
1 answer

Save a Sql file in pg-admin

I've have being trying to save an SQL query into a file in PgAdmin-4, but the save button seems not to get activated.
Sonola Moyo
  • 11
  • 1
  • 3
-1
votes
1 answer

Cannot save a new script on Pg Admin 4 while using Mac

I'm trying to save an SQL script on my computer storage but the Create button is disabled. Can anyone help with that. In this image the create button is disabled.
Aish97
  • 7
  • 1
-1
votes
1 answer

PgAdmin 4 unable to connect to the server on mac, i have postgres 14

PgAdmin 4 unable to connect to the server on mac, i have postgres 14 screenshot of problem, server can not be connected
MrJahid
  • 1
  • 2
-1
votes
1 answer

The json file can not be inserted into a PostgreSQL table

create table tmpdocs1(title text,abstract text,authors text,biblio text,pmid text); create table tmpdocs2(title text,abstract text,authors text,biblio text,year text,volume text,issue text,fpage text,page text,pmid text); COPY tmpdocsX FROM…
Nasduck
  • 1
  • 2
-1
votes
1 answer

docker pgadmin connect to Postgres failing

I'm trying to run pgadmin and postgres on docker. both services seems to work. However to able to connect to postgres through pgadmin. return password incorrect even after typing the password you see in the docker-compose…
Daniel Paul
  • 495
  • 1
  • 6
  • 13
-1
votes
1 answer

Issues creating a function

Thank you for reading my post and trying to assist. I am pretty new with PostgreSQL and am struggling with trying to create a Function to transform a table column that is currently integer (1,0) into 'Yes' or 'No" and redisplaying the table after…
Michele Ann Riedel
  • 3
  • 4
-1
votes
1 answer

EDITED: auto update timestamp every second in postgres

I have a column local_date_time (timestamp withhout time zone) in postgres DB and that needs to be auto updated every second based on speed like 1x, 2x(Increment by 2 Seconds for each 1 sec in real time) and so on. Suggest ways to do it within…
mdharaas
  • 1
  • 2
-1
votes
1 answer

uploading large file to AWS aurora postgres serverless

I have been trying for days to copy a large CSV file to a table in PostgreSQL I am using PGadmin4 to access the database. I have a file on my system the file is 10 GB so I am getting starting error when trying to upload it via UI or \copy command.
aadi sharma
  • 37
  • 4
-1
votes
1 answer

Hey there! I need you help. I successfully installed PostgreSQL but failed while opening pgAdmin 4. I keep getting this message, don't know what to do

I need you help. I successfully installed PostgreSQL but failed while opening pgAdmin 4. I keep getting this message, don't know what to do [Whenever I try to open pgAdmin4 I get this...]
Els Wt
  • 1
  • 1
1 2 3
…
78 79