Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [pgadmin]

pgAdmin is a graphical administration and development tool for PostgreSQL.

Current version as of 2015-02-25: pgAdmin 1.20.0
Details on the project home page.

267 questions
14
votes
6 answers

On pgAdmin 4, how to basically copy the content of one or two cells?

I decided to go on pgAdmin 4 instead of the 3 (I'm on Windows 7). It seems that this software if somehow still in a alpha state... I would like to only get the content of one cell. So I select this cell and tap Ctrl+C. But it seems NOT to copy the…
Louis V
  • 301
  • 1
  • 2
  • 7
13
votes
2 answers

How can I import my server list from pgAdmin 3 to pgAdmin 4?

I wonder whether there is any way to import my server list from pgAdmin 3 to pgAdmin 4 (so that I don't have to create servers one by one again).
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
11
votes
2 answers

How to execute multiple statement in PgAdmin 4 like we do in Sql Server/Oracle?

How to execute multiple statement in PgAdmin 4 like we do in Sql Server/Oracle (press F5)? select * from employees; select * from department; As much I worked with PgAdmin, it allows us to execute only one selected statement or last statement per…
user114198
  • 131
  • 1
  • 2
  • 6
9
votes
1 answer

PGAdmin 4 - server status / view log file

I recently upgraded to Postgresql 9.6 and PgAdmin 4. Now, one handy feature of PgAdmin 3 was the "server status" window, which I used to look at the log file. I can't find that in PgAdmin 4. How can I view the server log in PgAdmin 4? Or is there a…
mlinth
  • 281
  • 1
  • 3
  • 8
7
votes
1 answer

Auto-complete in pgAdmin: how to get it to automatically appear?

It looks like auto-complete is only activated after hitting ctrl + space https://www.pgadmin.org/docs/pgadmin4/4.12/keyboard_shortcuts.html This is unexpected to me: not quite as "auto" as I would expect an auto-complete feature to be. Is there a…
Michal Charemza
  • 181
  • 1
  • 2
  • 12
5
votes
2 answers

How can I disable the fade in and fade out effects in pgAdmin 4 when opening windows?

Is there any way to disable the fade in and fade out effects in pgAdmin 4 when opening windows? Example of fade in and fade out:
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
4
votes
1 answer

Query returned successfully when obvious error should occur

I have just installed postgresql and pgadmin on my Windows machine. The problem is that whatever I enter in query window, it results with message: Query returned successfully in XX msec. Even, when query is obviously incorrect, and should cause an…
Jakub Szułakiewicz
  • 143
  • 4
2
votes
2 answers

Is it possible to open an SQLite database inside pgadmin?

I was trying to find a way of opening SQLite databases inside pgadmin and I found this StackOverflow question where one solution points to importing the SQLite database inside PostgreSQL, and the other solution tells us to use PostgreSQL Wrappers.…
raylight
  • 123
  • 1
  • 4
2
votes
1 answer

How can I copy the content of a cell in the output pane where the latter is detached from the query window in pgAdmin III?

How can I copy the content of a cell in the output pane where the latter is detached from the query window in pgAdmin III? When the output pane is not detached from the query window, I can use control + C, but it doesn't seem to work when it is…
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
2
votes
0 answers

Will pgAdmin III let me run an SQL command that works after detaching from my SSH tunnel?

I just discovered pgAdmin III and I am absolutely overwhelmed by the number of options it offers. I'd like to try to replace my traditional workflow (psql ran over an SSH session) with this tool. The problem is that I usually work on a…
d33tah
  • 389
  • 1
  • 2
  • 10
1
vote
1 answer

How can I import a database dump (.sql) using pgAdmin without the PSQL Console plugin?

I am trying to import a database dump (.sql) using pgAdmin. I want to do it using only the GUI, not the PSQL Console (where I can import the sql dump using \i /path/to/yourfile.sql on Unix or \i C:\\yourfile.sql on Windows). Is that possible? If so,…
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
1
vote
2 answers

Can I have two Query Editor panels in pgAdmin?

Can I have two different Query Editor panels in PGAdmin, side by side? If not, is there another way of avoiding the pain point that's making me want two panels? That is: When I'm building up a complex query, there's so much back-and forth that using…
baudot
  • 225
  • 3
  • 6
1
vote
1 answer

Jump to a given line number in pgAdmin III

I wonder whether there is any way to jump to a given line number in the "edit data" window in pgAdmin III. I am aware that I can use the sort/filter window to add filters, but I just want to jump.
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
1
vote
1 answer

I cannot switch back to pgAdmin III's Database Designer's default font

I changed the default pgAdmin III's Database Designer's default font, which used to be MS Shell Dlg 2: I cannot set it back to the default font, namely MS Shell Dlg 2. Why? I don't see MS Shell Dlg 2 in the list of available fonts: Typing MS Shell…
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
1
vote
0 answers

How can I change the font in the "edit data" window in pgAdmin III?

I wonder whether I can change the font in the "edit data" window in pgAdmin III. I use Windows 7 and OS X 10.10.
Franck Dernoncourt
  • 2,083
  • 11
  • 33
  • 52
1
2