Questions tagged [pgadmin]
The pgadmin tag has no usage guidance.
56
questions
5
votes
3
answers
17k
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 ...