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

Output of Bytea datatype in pgdmin?

I have this very basic question but reason is I have not worked before with storing image datatype. I tried to search net but somehow not find an answer. My question is "What will be output of a select query containing a bytea column in pgAdmin"? I…
XCeptable
  • 1,247
  • 6
  • 25
  • 49
0
votes
1 answer

How to take entire database Store Procedure Scripts

How to take entire database store procedures full scripts same as the MS SQL 2008 R2 Generate Script feature. Need help.
barshan
  • 37
  • 7
0
votes
1 answer

Counting points/coordinates that lie within a bounding box

I have 2 tables. The first table contains following columns: Start_latitude, start_longitude, end_latitude, end_longitude, sum. The sum column is empty and needs to be filled based on second table. The second table contains 3 columns:…
Aman
  • 353
  • 1
  • 3
  • 13
0
votes
0 answers

Pgadmin4 SQL create table query no working in Postgresql command line on ubuntu 18.04

I created a table using pgadmin4 on windows. Then I copied the create table query from pgadmin4 SQL window and pasted in psql command line on ubuntu 18.04. It's raising following error: ERROR: relation "weather_measurements_meas_id_seq" does not…
XCeptable
  • 1,247
  • 6
  • 25
  • 49
0
votes
1 answer

pgAdmin4 not working anymore after restarting PC

I have a strange problem. I followed this tutorial to install pgAdmin4 on my Ubuntu 16.04 machine. It works fine until i restart my PC. When I try to run python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py from my ~/pgadmin4 directory, it…
Jakob Herk
  • 157
  • 11
0
votes
0 answers

Is there a way to insert a camelcase table name in pgadmin?

I have a DB with table names written in underscore format. I want to edit their names and also to be able to name every new table in a camelcase format Still, whenever I use a query to call a camelcase table name I have to do it using double quotes.…
Prometheus
  • 999
  • 2
  • 15
  • 28
0
votes
2 answers

Cannot connect postgresql database through pgadmin 3

I was trying to connect my database with my credentials through pgadmin3 interface but it shows authentication error. But I can connect that same database and access everything through the terminal with the same credentials. Is there anyone who got…
Rajeeb binRazaq
  • 31
  • 1
  • 1
  • 9
0
votes
0 answers

postgres locking problem with pgadmin3 and libreoffice

I have a postgresql database accessed from pgadmin3 and libreoffice. When it is accessed from multiple clients, it seems like only one client can actively access the database. Like there was an exclusive lock. Other clients do freeze. The database…
Árpád Magosányi
  • 1,394
  • 2
  • 19
  • 35
0
votes
0 answers

PgAdmin Server Status Blank

good afternoon I am facing a problem with pgAdmin - version 1.22.2 (Feb 11 2018, rev: REL-1_22_1) In the tools -> server status They are not listing the connections and processes, everything goes blank. Does anyone know how to fix it? I am using…
Geizon T.
  • 11
  • 5
0
votes
1 answer

Can a user write complex queries only with access to views?

I understand that SQL views are essentially prewritten queries, but can a user query from multiple views using commands like JOIN and DISTINCT etc. or are they only used for very basic queries?
Daniel64
  • 29
  • 2
  • 8
0
votes
0 answers

Access Postgres database in pgAdmin3 for user without password

I have created user in PostgreSQL database that don't have password. When I tried to connect to same user in pgAdmin3 it asks for password for the user every time I want to connect to server. what i did was following:sudo vi…
codeScoop
  • 1
  • 1
  • 3
0
votes
0 answers

how to sync databases between PSQL and pgAdmin

please refer to this post. Separated pgAdmin and cmd psql databases it hasn't been answered yet. Please help postgres users.
Karl Garcia
  • 45
  • 11
0
votes
1 answer

Configuring nginx to map pgadmin to a URI

I have an nginx and a pgadmin Docker container connected to each other. Only nginx container is exposed to the outside. How can I map pgadmin to a sub URI? If the host is example.com, I want the pgadmin to be reachable at example.com/pgadmin/. So…
yam
  • 1,383
  • 3
  • 15
  • 34
0
votes
0 answers

Connect pgAdmin to a remote server container

I have a remote Linux Ubuntu server that has a container running PostgreSQL database. Is possible to use my local pgAdmin and connect to this remote server database container?
Bug
  • 832
  • 2
  • 9
  • 37
0
votes
1 answer

Export table in PGAdmin

I have a table in my PGADMin and I want to export it into Insert Statements so that I can use it in a backscript. When I try the backup option I keep getting encoding issues
Rester Test
  • 227
  • 2
  • 10
1 2 3
…
99 100