[dsp1234]

like pgAdmin, for example, since IntelliJ IDEA is just far superior at doing the same thing, and it's just right there where you code.

You don't mention the two things together, but VS has the server explorer which you can use to hook in to a database and do administrative tasks (both design and data viewing)

[gelasio]

Also pgAdmin is about as feature-ful as Notepad is so it's not hard to do something a little better.

Besides server explorer, VS also has SSDT (SQL Server Data Tools) obviously only for SQL Server, but I've never seen anything even in the same league as SSDT for any open source database.