How to configure pgAdmin III to open default database and select tables node on startup?

Question

99% of the time when I start pgAdmin III, I need to look at the tables of one specific database. It is very annoying to click through the tree every time. When I open pgAdmin, I would like it to automatically connect to my last database and expand the tree on the left and select the "tables" node.

Is that possible?

What is also annoying is when I rename a column, the tree node selection is lost and I have to open the whole tree again.

Answer 1

There is a related option: Restore env. It's on by default.

Open the context menu for a (closed) connection and go to the "Advanced" tab. I quote the manual of pgAdmin 1.16 here:

The “Restore env?” option determines whether or not pgAdmin will attempt to restore the browser environment when you reconnect to this server. If you regularly use different databases on the same server you might want to turn this option off.

It doesn't pin down one particular state for ever, but reopens where you left. Since you are in the same spot 99% of the time, that should work just fine for you.

Your second issue (browser losing focus after DDL change) is a bug of the current version for all I know.