(The GUI solutions persist the browsing results automatically in a separate window.) As the databases get more complex (and varied), it is much easier to use a visual database browser than to have to constantly type in cryptic backslash-d commands and try to remember the results. Most of the GUI based clients include an easy database browser - so you can at a glance see the tables and functions and materialized views and schemas. You can sort of do this by opening multiple terminal windows each with a different psql session, but it is hard to keep track of them and it requires setting up a bunch of environment settings, which is hard to keep secure. Most of the other clients maintain an easy list of connection options, so you can connect to multiple database servers at the same time and/or with a variety of database users. ![]() Here are a few reasons why GUI clients are more popular: ![]() ![]() It is what I use most of the time these days because I haven't found a GUI client that I like since SQLExplorer was abandoned.
0 Comments
Leave a Reply. |