The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
107 views

pgAdmin III - how to insert data into table

How can I insert the result of some function (e.g. point(0,0) or localtimestamp) into some cell in the edit data window of pgAdmin? I keep getting an error Invalid input syntax for type ...
0
votes
1answer
244 views

Any way to keep connection alive in pgAdmin without setting it on the server?

I am using postgres.heroku.com to host my databases. This means that I have no way of changing server settings. Therefore, the answer to this question does not help me. Heroku is not willing to change ...
2
votes
1answer
545 views

How can I completely uninstall pgAdmin3 from OS X?

My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the ...
0
votes
0answers
128 views

Cannot copy-paste multiple rows in PgAdmin

I don't understand why this is not working. I have one instance of PgAdmin in which I administer multiple databases on multiple servers. I wanted to copy some rows of a table from one database on ...
0
votes
1answer
405 views

How display result of multi select in PgAdmin III?

select 1 as a,4 as b, 5 as c; select 1 as a,3 as b; Result display only of `select 1 as a,3 as b; How display result of multi select in PgAdmin III?`
0
votes
1answer
707 views

How to keep connection alive in pgAdmin

In pgAdmin, if I'm connecting to a host and leave it idle for a few minutes, the connection drops, and I have to reconnect again. On many occasions pgAdmin also hangs when I try to reconnect, so I ...
0
votes
1answer
86 views

Why does PgAdmin III give warning that PgAdmin.exe has disappeared from C drive?

So I'm currently working with PostgreSQL, PostGIS, p-mapper, and QuantumGIS to build a web-mapping system. And earlier this morning, I opened PgAdmin III just to check on my database, no editing, no ...
1
vote
2answers
1k views

pgAdmin list of keyboard shortcuts

I've been using pgAdmin for several days and so far I like it. However, I can't find a list of keyboard shortcuts documented anywhere, either on the pgAdmin site, in the help, or in the options menu. ...
1
vote
1answer
511 views

Set default search path in pgAdmin

Every time I open pgAdmin I have to do this: set search_path="schema"; Is there a way to set a default search path value?
0
votes
1answer
109 views

Hide some functions from display in PG Admin III

I have installed modules (XML2, UUID) in Postgres. In PG Admin III, all the functions contained in those modules display under the "Functions" tree. The list is lengthy, and it slows down my work ...
1
vote
2answers
3k views

How to install pgAdmin

I use Ubuntu 12.04 64 bit. At first I installed pgAdmin through Software Center. But it seemed old. So, I decided to uninstal it. Then I downloaded graphic installer for PostgresQL. sudo ...
0
votes
1answer
9k views

How do I restore a plain text postgres .backup file

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is ...
2
votes
1answer
1k views

Searching a whole postgres db for a string

In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at ...
1
vote
0answers
419 views

Can't view database structure via pgAdmin, while psql works ok

I have a PostgreSQL database. I can connect to it via psql no problem, however, when I do database listing: my_database=>\l there is no my_database in the list! When I connect to this same ...