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
1 answer

Localhost Rails Server Error Loop

cd project rails server /usr/local/Cellar/ruby/2.5.1/lib/ruby/2.5.0/fileutils.rb:90: warning: already initialized constant FileUtils::VERSION /usr/local/lib/ruby/gems/2.5.0/gems/fileutils-1.1.0/lib/fileutils.rb:92: warning: previous definition of…
Stephanie
  • 105
  • 1
  • 10
0
votes
0 answers

Postgres /Pgadmin Convert Characters t/f to Boolean values (TRUE/FALSE) in target database

I have a CSV file that contains a number of columns with t / f values. I'm trying to write this data to Postgres using pgadmin. The columns in the target table in postgres are set to type boolean which only accepts 'TRUE' 'FALSE'. How might I…
Keith C.
  • 1
0
votes
1 answer

how set a fixed por in pgadmin4 because he open rand

It's possible to fix a port in pgAdmin4? everty time I restar my mac he open in a random port. I look in google and don't find anything
Fabio Ebner
  • 2,613
  • 16
  • 50
  • 77
0
votes
0 answers

Trying to compile pgAgent. Get an error wx/setup.h: No such file or directory

On one of our servers pgAgent service does not start with the message "ERROR: Couldn't register event handle" (see DBA Question). So I decided to compile the binary from the source, to further investigate the problem. I installed Visual Studio…
arthur
  • 1,034
  • 2
  • 17
  • 31
0
votes
1 answer

pgAdmin III shows duplicate connection to same server

My pgAdmin suddenly shows two connections to the very same server (localhost). I can't remember what particular actions I did the last time before opening the software today. Both servers contain the same databases and login roles. Q: Why does…
payloc91
  • 3,724
  • 1
  • 17
  • 45
0
votes
1 answer

Timestamps comparison in postgres

I have two queries with similar data(one with previous period and other with current). I need to display this in a kendo line chart. How can I do so** select date_trunc('hour' , "CreateDateTime"::TIMESTAMP) as c, count(1) as d from "ROBOT"…
Megha M
  • 105
  • 1
  • 10
0
votes
2 answers

Find user with higher profits in a postgresql table

I have a table in my database whose structure is like this sell_id(int) | car_id(int) | worth(int) | date(date) | selled(boolean) Selled is a wrong 'sold'. My table is like this ------------------------------ 50 |50 |2405 | "2012-07-16" | false 51…
MonkeyDkon
  • 54
  • 11
0
votes
0 answers

For xml - similar function in postgresql

the 'for xml' command does not work on pgadmin. Any ideas? I'm trying to get the following query to work from another stackoverflow question: SQL For xml path on int columns? select @contactIds = stuff((select ','+cast(id as varchar(8000)) …
emma loves data
  • 1
  • 1
0
votes
1 answer

Can't remember my postgres user password to connect server

I'm working in this Django app but I stopped working on it per two weeks, so my computer was off during this time. Now I want to work on it again this error appear to me over and over again in my command line, I opened pgAdmin and found is because I…
Enrique Vargas
  • 159
  • 2
  • 13
0
votes
1 answer

pgAdmin won't run standalone

I'm running Debian 9 with separate root e home partitions, installed postgreSQL and pgAdmin4 following these steps: sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main" > /etc/apt/sources.list.d/pgdg.list' sudo apt-get…
marcelorc
  • 3
  • 1
0
votes
1 answer

Heroku PostgreSQL 1700 databases

I got PostgresSQL on Heroku because I'd like to store data that I capture in my web app. It took me a while to learn how to use docker so I got distracted, I finally got round to connecting my web app to postgres. I found the credentials on the…
Alec Davies
  • 127
  • 11
0
votes
0 answers

How can I copy/transfer/restore a table (Not entire database ) from one PostgreSQL to another through Heroku CLI?

I'm looking possible way to copy some tables of one PostgreSQL DB to another DB. With PGAdmin, backup and restore is really confusing and mess. Is there a way to backup and restore specific tables via Heroku CLI? Or some other ways?
Jijil Kakkadathu
  • 343
  • 3
  • 17
0
votes
1 answer

Query returning different number of rows, results in crosstab error

I get this error with my query, but I can't figure out what is wrong with it: Query-specified return tuple has 135 columns but crosstab returns 295. And here's my query: (The part highlighted in bold returns same number of rows when run separately…
Sylph
  • 1,425
  • 3
  • 26
  • 36
0
votes
0 answers

Win32 batch scripts always fail pgAgent

PostgreSQL batch script always fail not running. below job script query.... DO $$ DECLARE jid integer; scid integer; BEGIN -- Creating a new job INSERT INTO pgagent.pga_job( jobjclid, jobname, jobdesc, jobhostagent, jobenabled…
user619
  • 149
  • 2
  • 2
  • 13
0
votes
1 answer

Is a postgres index updated automatically?

In my pgAdmin 3 I have a option in the context menu on index that says update. Does this mean an index is not updated automatically on every insert? If that is the case, how can I configure it to update itself?
Veselin
  • 197
  • 2
  • 12
1 2 3
…
99
100