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
218
votes
6 answers

Connect to a heroku database with pgadmin

I would like to manage my Heroku database with pgadmin client. By now, I've been doing this with psql. When I use data from heroku pg:credentials to connect de DB using pgadmin, I obtain: An error has occurred: Error connecting to the server:…
Tomas Romero
  • 8,418
  • 11
  • 50
  • 72
206
votes
5 answers

How to hide databases that I am not allowed to access

When I connect to my Heroku - Postgresql database via pgAdmin3, It lists all the tables (about 2600). Every time I open the pgAdmin3 I have to find my own database. Is there a way to hide databases that I'm not allowed to access ?
alioguzhan
  • 7,657
  • 10
  • 46
  • 67
200
votes
30 answers

docker postgres pgadmin local connection

I have created an ubuntu image with nginx, php and postgres. I want to connect the postgres database in my current image with pgadmin located on my local machine. I have tried using docker inspector to try to use the image ip to make a connection…
Rigoxls
  • 2,117
  • 2
  • 13
  • 5
170
votes
2 answers

How to add multiple columns to a table in Postgres?

How do I add multiple columns in one query statement in PostgreSQL using pgadmin3?
Hick
  • 35,524
  • 46
  • 151
  • 243
163
votes
3 answers

Export Postgresql table data using pgAdmin

I am using pgAdmin version 1.14.3. PostgreSQL database version is 9.1. I got all Db script for table creation but unable to export all data inside tables. Could not find any option to export data in db script form.
Muhammad Imran Tariq
  • 22,654
  • 47
  • 125
  • 190
131
votes
6 answers

Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 installed on my machine. For exporting a table dump, I do: Right click on the table => Choose backup => Set Format to Plain => Save the file as some_name.sql Then I remove the table. Ok, now I need to import the backup…
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
129
votes
6 answers

How to connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later…
TuGordoBello
  • 4,350
  • 9
  • 52
  • 78
110
votes
5 answers

PostgreSQL how to see which queries have run

I have a PostgreSQL DB at my computer and I have an application that runs queries on it. How can I see which queries has run on my DB? I use a Linux computer and pgadmin.
kamaci
  • 72,915
  • 69
  • 228
  • 366
108
votes
4 answers

Postgres DB not starting on Mac OSX: ERROR says: connections on Unix domain socket

I ve installed Postgresql and then ran a bunch of rails apps on my local Mac OSX Mountain Lion and created databases etc. Today after a while when I launched pgAdminIII and tried to launch a database server I got this error: A quick google showed…
banditKing
  • 9,405
  • 28
  • 100
  • 157
77
votes
6 answers

pgAdmin 4 always open in browser not as a standalone desktop application

installed PSQL10 but when pgAdmin is run from start then always open in browser.There is no option to run as a Desktop Application
user2006500
  • 781
  • 1
  • 5
  • 3
75
votes
5 answers

How to visualize database tables in postgresql using pgAdmin?

I am trying to visualize tables and their relations using pgAdmin. I have understood that there is a query visualizer tool available for pgAdmin. However, that only is useful if you are dealing with queries. My main goal is to generate a graphical…
sheidaei
  • 9,842
  • 20
  • 63
  • 86
70
votes
6 answers

Create new local server in pgadmin?

I have PostgreSQL 11 and PGadmin 4 installed on windows. Currently I'm connected to a AWS server which hosts all of my data. I want to create a local server (localhost) as a testing environment where I can experiment. I can't seem to do it though,…
Theo F
  • 1,197
  • 1
  • 11
  • 18
67
votes
3 answers

Debug PostgreSQL function using pgAdmin

I refer this to enable the debugger in the PostgreSQL server in order to debugging the plpgsql function by stepping through the code using pgadmin. I have already set shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' in the…
Ken Chan
  • 84,777
  • 26
  • 143
  • 172
57
votes
5 answers

Primary & Foreign Keys in pgAdmin

I was wondering can some give me an explanation on how to assign primary and foreign keys in pgAdmin? I can't find any information online. For example...I've got a Student table with all their details (address, d.o.b. and etc.). I'm going to add a…
Mr Teeth
  • 1,269
  • 5
  • 19
  • 23
56
votes
3 answers

In PostgreSQL, how to insert data with COPY command?

I have problem when run 1 project NodeJs with PostgreSQL database. I have error when trying to insert data in pgAdmin using the COPY command. COPY beer (name, tags, alcohol, brewery, id, brewery_id, image) FROM stdin; Bons Voeux blonde 9.5…
user4646310
1
2 3
…
99 100