Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
56
questions
4
votes
1
answer
24k
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 ...
3
votes
1
answer
4k
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?`
9
votes
2
answers
21k
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
1
answer
282
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 ...
12
votes
3
answers
32k
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.
...
5
votes
3
answers
16k
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
1
answer
1k
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
2
answers
9k
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 ./...
1
vote
1
answer
19k
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 ...
5
votes
2
answers
18k
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
0
answers
2k
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 ...