Answer the question
In order to leave comments, you need to log in
GUI or console for working with PostgreSQL?
I just started to learn databases and SQL, so banal advice will also be useful to me)
1. Is it possible to constantly use the GUI to work with Postgres?
I am good friends with the console, but when working with databases, there are often things that are not convenient to do in the console, even in theory. The most banal example is viewing the contents of tables. It is not convenient to view a large table without graphic design.
2. If you advise using a GUI, which one? I understand that the two best options are pgAdmin and Navicat. I am generally a front-ender for the most part and love the beautiful design and ease of use - here, no doubt, Navicat is ahead, but I began to encounter some inconveniences: for example, in pgAdmin, "SQL Pane" panels are poked everywhere, in which all the code generated for the selected element is written . For example, if you select a table, then in the SQL Pane there will be a code with which you could create a table in the console - this is convenient. I think as you study these differences there will be more.
Answer the question
In order to leave comments, you need to log in
Well, why is it? I personally don't use the GUI. As a last resort, a built-in solution in the IDE from JetBrains.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question