The use of PostgreSQL graphical client tools have you got it?

PostgreSQL database has been widely used as an open source database with strong function. The TSA uses the database to store some of the processed business data. Although PostgreSQL itself provides the command line Interactive client tool Psql, the character interface tool requires frequent write SQL statements for querying, and the data is not visually visible. The Green League June uses the evening's spare time to organize the use of the PostgreSQL Graphical client tool to share with you.

Article Directory

• 1. Install the connection
• 2. Very small tricks
  • Where
  • Order by
  • Group by
  • SQL Editor
  • Precautions
• 3. Concluding remarks

1. Install the connection

Download cracked version of the installation package Postgresql_maestro_setup.exe, light-weight installation is very convenient, minutes to get it done.

After installation, you can use Maestro to connect to the database, and the connection interface is as follows:

Enter the IP, port number, username and password of the host to which you want to connect the database, Next->next.

Double-click the database name in the left window to open the database, double-click the table name under the schema to view information about the table, as shown in:

Properties to display the database, you can list all the fields in the database;

Data display, select data can be viewed in the database, the branch display;

Click SQL to view the build table statement.

2. Very small tricksWhere

When the tab in the table switches to data, click All event_type values in the presentation data

You can select an event type filter so that you can quickly filter out the data you want to query without having to write a SELECT statement.

Order by

Right-click Event_type, pop-up menu box.

The filtered data can be further processed

Sort Ascending: Sort the data in ascending order;

Sort desending: The data is processed in descending order;

Advanced Sort: Premium sorting Options box, which can be configured as needed

Clear sorting: Clear sort

Group by

Right-click the field that requires group by, select group by this Filed, and the results are as follows:

This way the data is clustered according to the selected field, and by clicking the "+" before the grouping, you can see the details of the data under that grouping.

How to cancel group by it?

Right-click on the Group By field, select Remove from grouping, you can cancel, of course, you can also choose to drag the field directly to the same way to cancel.

Group by Box

Select the field, right click on select group by BOX, the interface shows as follows

By can only, Group by box essence is actually a sort of collation.

SQL Editor

For students who are accustomed to writing SQL statements, Maestro also provides powerful editing capabilities.

Click the menu bar Tools, select SQL Editor, as follows:

Open the SQL Editor box and enter the SQL statement.

Click on execute, the interface will show the query results, as follows:

Similarly, Maestro has the function of SQL Script Editor, as follows:

Precautions

During use, you may find that 1-3 of the data is queried, and 4 or inconsistent with the data displayed by the system business. Yes, when the data in the table is less than 1000, the data that 1-3 queries to and 4 is exactly the same as the data that is queried by SQL. However, when the data in the table exceeds 1000, 1-3 of the data queried is not the full table data. This is because maestro default paging is 1000.

You can modify it in the red box above, but return 1000 when you refresh or log back in.

The maximum value can be set to 5000, if the setting is greater than 5000, the following conditions will occur, no drop-down black triangle, function 1-3 is not available.

Do not worry, just click on the hint in the Blue font "options", you can also select the menu bar tools->options, open the following dialog box

You can modify the default values according to the amount of data in the table, adjust to a larger number, once and for all, so that you can freely, carefree use.

3. Concluding remarks

Familiar with the use of Masstro skills, just a little bit can save a lot of SQL statements written, simple and fast. If the above-mentioned use of skills summarized, the new students in the use of the process to play some guidance role, but also can weakly improve the efficiency of the other students, the use of finishing time has become meaningful.

There are, of course, some other graphical client-side tools, such as PGADMINIII, Navicat for PostgreSQL. Just take a moment to explore and familiarize yourself with it and use it quickly and easily in future work.

The use of PostgreSQL graphical client tools have you got it?