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
2 answers

Docker PGAdmin Container persient config

I am new to docker. So what I want to have is a pgadmin container which I can pull and have always my configs and connections up to date. I was not really sure how to do that, but can I have a Volume which is alsways shared for example on my Windows…
Matthias
  • 485
  • 7
  • 21
0
votes
1 answer

pg_catalog does not exist in AWS RDS PostgreSQL

I am trying to view pg_catalog.pg_stat_activity in pgAdmin 4, but I cannot seem to find where it is (if it exists) on my RDS PostgreSQL DB. Where should it be? There is no pg_catalog schema, and I have made sure that the correct parameters are…
Brandon
  • 41
  • 7
0
votes
1 answer

Why do I keep getting INSERT error: has more targets than expression

Me again, This time I am working on a pg admin sql database and I'm trying to figure out why I am getting this error, I have an insert statement but it keeps saying error: INSERT has more targets than expression, I don't really know why I am getting…
Jessica Simcoe
  • 23
  • 1
  • 1
  • 5
0
votes
1 answer

Binding parameter in SELECT query for PostgreSQL

select (CURRENT_TIMESTAMP - '60 days'::interval); This shows me a current time stamp with an interval of 60 days getting subtracted. SELECT VALUE FROM schema_name.some_parameter WHERE some_parameter.NAME LIKE 'some_reference_name' I want…
champ.exe
  • 125
  • 16
0
votes
0 answers

What does WALInitSync actually mean?

I am using postgresql and pgadmin. I had a table (about 12 million rows) from another database which I wanted to transfer to a table in a new database. So I created a custom backup of that table and tried restore for the new table. The Restore job…
Mike
  • 369
  • 5
  • 21
0
votes
0 answers

Postgresql Server doesn't listen localhost

I'm new on Postgresql, and here I'm trying to make a connection between Python3 and Postgresql. Now I'm trying to create a new database on post 8888 on localhost. Here's my code from Python 3, and also when I try to debug this code, I do get a…
J.Macro
  • 3
  • 3
0
votes
1 answer

How to save pgAdmin layout

Each time I re-open pgAdmin I have to open the path to my database tables. Is there a way to have the path saved so it automatically re-opens to the desired layout?
SimonRH
  • 1,409
  • 2
  • 13
  • 23
0
votes
1 answer

How do I connect to postgres database that do not use password with pgadmin3..?

I have a postgres database that I set up with SQLAlchemy, with this code: SQLALCHEMY_DATABASE_URI = "postgresql:///mydb" And now I want to manage my database with pgAdmin3, but I'm confused because don't know how to connect it with the username and…
Tri
  • 2,722
  • 5
  • 36
  • 65
0
votes
0 answers

Postgresql & PgAdmin SIMPLE variable

I don't understand why creating variables has to be so complicated in pgAdmin but can someone please help me with this concept. I would like to just create a basic variable that is a Name from a record. And then I want to search for that Name again.…
Freddy Bonda
  • 1,189
  • 6
  • 15
  • 33
0
votes
1 answer

Postgresql & pgAdmin: Add a default column to every new table in database

Postgresql & pgAdmin: How can I add a column to every table that is created in my database? I want to add a "GUID" and "CreateDate" column by default to every single table that will ever be created in my database. So if I do: CREATE TABLE my_table…
Freddy Bonda
  • 1,189
  • 6
  • 15
  • 33
0
votes
0 answers

A very difficult export. How to export a single table's content from the backup as a CSV postgres

I am using pgAdmin to load the backup into memory, but it is very slow due to the size of the backup. Also I have to use PostgreSQL server to restore data. I have lots of ~10GB compressed backups and they require to restore ~7h each, then I use an…
cuga
  • 123
  • 1
  • 8
0
votes
1 answer

Aurora RDS Postgres - Connect over SSL using PgAdmin3

I have created a RDS Aurora PostgresSQL Cluster. It is accessible publicly and SSL is enabled. I have completed the entire flow of connecting the instance over SSL using datagrip. I would like to do this same thing using PgAdmin3 , but unfortunately…
Shivkumar Mallesappa
  • 2,875
  • 7
  • 41
  • 68
0
votes
0 answers

PostgreSQL does not return a XML with table data

I am using the latest ProgreSQL on a iMac. When I use a simple SQL statement for returning a XML from a table but it doesn't return the data. SQL: select table_to_xml('company',true,false,''); (I also tried '"company"') Returns only xml: company…
Chris Gerrist
  • 1
  • 1
0
votes
1 answer

Pgadmin4: Invalid HTTP Version 'Invalid HTTP Version: 'on postgres@domain.tld HTTP/1.0''

-------------------------------------------------------- | Pgadmin version | 4.3.5 | -------------------------------------------------------- | PostgreSQL server version | pg_ctl (PostgreSQL) 11.1…
Bloody Altair
  • 13
  • 1
  • 5
0
votes
1 answer

How can I import a pg_dump via PgAdmin4 without psql? "[archiver] input file appears to be a text format dump. Use psql."

I am trying to import a pg_dump from a Linux machine called "dump.sql" into a windows machine that has PgAdmin4 that does not have psql working. I keep getting this error message: pg_restore: [archiver] input file appears to be a text format dump.…
S. Shao
  • 61
  • 5
1 2 3
…
99 100