Like most people working with databases, we initially used the vendors' tools. These included applications like SQL Plus, PL/pgSQL, etc. They all are a bit limited and all respond differently to edits. Tools like Toad, PL/pgSQL developer, pgAdmin, and DBeaver have been in use but no tool could win here. Maybe some other tool has more options in a specific database but a lot of people have trouble finding them because of the cluttered interface. There are buttons for every feature. Here, DbVisualizer, shows strong and smart use of context menus, making the GUI a lot cleaner than most similar tools.
