6.11. SQL tool

The SQL tool, or Manage view, provides a simple but functional interface where the user can manage databases in different ways like browsing objects, sending any sort of SQL commands into a PostgreSQL server via SQL execution panel as well handling data in tables by using the data manipulation dialog.

Some other features that this widget supports are the use of code snippets, code completion, load saved SQL script files, export the results returned by the command execution and many others. Note that the SQL tool does not intend to be a replacement for any database management software. It still lacks a lot of features that great open source projects like pgAdmin and phpPgAdmin implement. The main goal of the SQL to is to provide a quick way to execute small tasks over databases without leaving pgModeler's graphical user interface.

The SQL tool is divided in two sections (see the image below), the Database explorer (on the left) and the SQL execution. The first one is used to browse databases and manage their objects. The second one is where the user can run SQL commands in the database server and perform other related operations. Details about these sections will be given in the following subtopics.


pgAdmin Project

http://pgadmin.org

phpPgAdmin Project

http://phppgadmin.sourceforge.net

Sep 3, 2018 at 16:03