Stack Overflow
Stack Overflow

Questions tagged [pgadmin]

pgAdmin is an Open Source administration and development GUI for PostgreSQL.

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. There are native builds available for Linux, FreeBSD, Solaris, Mac OSX and Windows. Use it to manage PostgreSQL 7.3 and above running on any platform, as well as derived versions such as Postgres Plus Advanced Server and Greenplum database.

The graphical interface covers anything from writing simple SQL queries to developing complex databases. A new major version is usually released in connection with every major version of PostgreSQL and supports all PostgreSQL features. It includes an SQL editor with syntax highlighting and a graphical query builder, an SQL/batch/shell job scheduling agent, support for Slony-I replication engine, a scripting engine and much more. Connect to any server via TCP/IP or via Unix Domain Sockets on *nix platforms, optionally SSL encrypted.

pgAdmin is available in many languages. It is Free Software released under the PostgreSQL License. The latest version as of 2012-10-26 is 1.16.0

1862 questions
0
votes
0 answers

Dockerized pgAdmin4: explain functionality not working / tables not visible in UI

I've been trying to fix this for two days now. I've followed a tutorial to setup postgres with pgadmin using docker. Since I need postgis I modified the tutorial to get the following docker-compose.yml file: version: '3' services: …
user3091275
  • 1,013
  • 2
  • 11
  • 27
0
votes
1 answer

Postgres get the different objects from different group in the same model

I currently have trouble figuring out how to get the different objects that exist in this group by a field to another group by the same field but different value. I'm using sqlalchemy to connect my flask to postgresql I have the ReferenceCity model…
Linh Nguyen
  • 3,452
  • 4
  • 23
  • 67
0
votes
1 answer

How to connect simple website to RDS PostgreSQL DB

This is possibly a broad question: I've been teaching myself how to program for the last year. I've learned how to create simple websites using HTML, CSS, and JavaScript. I've also learned how to create simple databases using PostgreSQL. I need help…
Fissure
  • 229
  • 4
  • 9
0
votes
1 answer

PGAdmin generate backup sql with inserts in correct order

I need dump database into 2 sql files : ddl script and dml script. I used pgadmin's gui, clicked on backup and check only Only schema option to create ddl. Next I did same operation, but I clicked Only data to create dml. Problem is with insert…
Denis Stephanov
  • 4,563
  • 24
  • 78
  • 174
0
votes
0 answers

How to run SQL script without losing data in Pg Admin |||?

I am working on PostgreSQL database and after some months I have added new columns in many tables according to the new requirements on my test server and also I have done changes in functions. Now what I want that I want to do same changes on my…
Moin Khan
  • 674
  • 2
  • 9
  • 27
0
votes
1 answer

pgadmin error while connecting to docker postgres instance: "The server encountered an internal error and was unable to complete your request."

I'm running a postgres image from a docker container. While trying to access it from the pgadmin 4 GUI client, I'm getting the error: "The server encountered an internal error and was unable to complete your request. Either the server is overloaded…
user9652688
0
votes
3 answers

How to run a true procedure in pgAdmin and evaluate results

I haven't seen any question that covers all of what I'm asking, so for grins am posting my journey here. The task: Run, in pgAdmin, a procedure (not a function) in Postgres. Evaluate and report back the results to the user on-screen. For my…
Wellspring
  • 1,128
  • 1
  • 10
  • 19
0
votes
1 answer

How to use simple quotes in strings using the command "insert into" on pgAdmin III

I've made a Java code that reads a text document and returns me a list of sql commands (insert into) that I copy and paste on pgAdmin III so it can insert the data read in its database. As you know, the insert into comand uses simple quotes to wrap…
Thiago Resende
  • 177
  • 1
  • 1
  • 8
0
votes
0 answers

Export PostgreSQL DB with only 100 records per table

I'm workink on rails app with postgreSQL database. The database has differents schemas. One of them stores reference datas and is used in read-only mode. In development and production environment, datas are loaded from a flat file datas.SQL . As it…
Thibaut G
  • 31
  • 1
  • 5
0
votes
0 answers

function not responding with desired result?

I'm able to create a PL/pgSQL function successfully. But while running a function it response like below SELECT __find_locations() Successfully run. Total query runtime: 236 msec. 867 rows affected. But I'm expecting it to return 867 rows My…
Rajath
  • 2,611
  • 8
  • 27
  • 43
0
votes
1 answer

How to upload script on pgadmn?

I cannot upload the script on PGADMN. Please help me in resolving error. SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET…
Vivek Gupta
  • 1
  • 3
0
votes
0 answers

Import CSV in PGAdmin 3 with autoincrement ID

I want to import CSV in PGAdmin III with ID field auto increment. I am not able to do it. The CSV contains a column as ID with null values. need help.
Apurva
  • 9
  • 2
0
votes
2 answers

How to get rid of extra Postgres databases shown in pgAmin?

I am having a Postgres database deployed. When I connect to it using pgAdmin I see so many databases that I don't have access to and I haven't created at all. The picture shows some of them. My actual database is one of them. What are these database…
Lee Maan
  • 699
  • 3
  • 10
  • 30
0
votes
1 answer

How to copy data from csv file into table with name user in Postgres?

I am trying to copy user information from csv file into Postgres database and the table name is user. I can import data from pgAdmin manually. However if I run the COPY user(columns) FROM csvfile... command, it is giving me Syntax error at user. Is…
Underoos
  • 4,708
  • 8
  • 42
  • 85
0
votes
0 answers

Pgadmin removes brackets in case when statements when not desired

I try to create CASE WHEN statement with multiple values with OR and AND operators. I have 3 statements that should give value 1 when at least one of them is true. Using brackets I ensure that I have 3 cases. Anyhow pgadmin removes brackets and I…
dmitriypetrychukmiete
  • 5
  • 4
1 2 3
…
99 100