Navicat for PostgreSQL v16.3.9 64-bit Chinese Enterprise Edition (with tutorial)

Navicat for PostgreSQL is the best postgresql database management tool available on the Internet, with a graphical interface that allows you to create and run queries with a powerful SQL editor, functions, and manage data with versatile data editing tools. In addition, the software can connect to any local or remote PostgreSQL database server 7.3 or later, and supports all PostgreSQL database objects. Need friends can download and try it!

Navicat for PostgreSQL is designed for novice or professional developers who use PostgreSQL servers to not only write simple SQL, but also develop complex databases. Key features include SQL creation tools or editors, data model tools, data transfer, import or export, data or structure synchronization, reporting, and more.

Navicat for PostgreSQL 32-bit download

Usage method

navicat for postgresql provides the following four functions: ● Query language functions (functions written in SQL) ● Procedural language functions (such as functions written in PL/Tcl or PL/pgSQL) ● Internal functions ● C-language functions Each function can accept primitive types, compound types, or combinations as arguments (arguments). In addition, each function can return a primitive type or a compound type, and many functions can accept or return certain virtual types (such as polymorphic types), but existing facilities vary. Click the function icon to open the list of function objects. Function Wizard Click "New Function" on the toolbar of the object list. The function wizard pops up and you can create a function. When you create a new procedure or function, you can do so without showing the Function Wizard. If you want to display the wizard, you can enable it in Options. 1. Define the parameters of the function. Set parameter mode, type mode, type, name, and default values in the corresponding column. 2. Select a mode and return type from the list. Definition A definition includes a valid SQL procedure statement. This can be a simple statement, such as SELECT or INSERT, or a compound statement written with BEGIN and END. The compound statement can contain statements declaring loops and other control structures. Parameters: Define function parameters. Return Type Mode and return type: The return type of the function. To run the function as a result, click "Run" in the toolbar. If the SQL statement is correct, the statement will be run and return data, and the "Results" TAB will open with the data returned by the function. If an error occurs while running the function, the operation stops and the corresponding error message is displayed. If the function requires input parameters, the Input Parameters box will pop up. Separate the parameters with commas (,). Tip: Navicat for PostgreSQL supports returning 10 result sets. navicat for postgresql views navicat for postgresql views are used to access a set of associations (tables), just like a single table, with restricted access. Views can also be used to restrict access to rows (a subset of a particular table). Click the View icon to open the list of view objects. Users can create a view shortcut by right-clicking on the object list view and selecting "Create Open View Shortcut" from the pop-up menu. This option is used to provide a convenient way to open a view without opening the main Navicat. ● Preview: Preview the results of the view. ● Explanation: Display the query plan of the view. ● Beautify SQL: The Beautify SQL option sets the format of the code in the editor. Tip: Users can choose how to render the results by selecting View -> Show Results -> under the Query Editor or in a new TAB. View Creation Tool (Full version only) View Creation tool allows you to create and edit views visually, even if you do not know SQL. The definition user can edit the view, defined as an SQL statement (SELECT statement that it implements). Rules Use the name edit box to set the rule name. Event: An event is one of SELECT, INSERT, UPDATE, or DELETE. Run instead: Indicates that these commands should be run. Condition: Any SQL conditional expression (returns boolean). With the exception of NEW and OLD, conditional expressions do not necessarily reference any tables and may not contain aggregate functions. Definition: A command that constitutes a regular action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY. In conditions and commands, special table names NEW and OLD may be used to refer to values in the reference table. ● NEW is valid for ON INSERT and ON UPDATE rules, referring to the new row being inserted or updated. ● OLD is valid for ON UPDATE and ON DELETE rules that refer to existing rows that were updated or deleted. Comments: Comments that define the rule. Advanced Property owner: The owner of the view. View Viewer View Viewer displays view data in a grid, and data can be displayed in two modes: grid view and form view.

Software feature

1. Navicat Cloud Navicat for PostgreSQL provides the Navicat Cloud service to users, synchronously connecting Settings, models, queries, and virtual groups to the cloud. So you can access it anytime, anywhere, in real time. With Navicat Cloud, you can make the most of every minute of the day and maximize your productivity. 2, Secure connection Navicat for PostgreSQL creates secure SSH phase jobs through SSH channels to ensure that the connection between two hosts is protected by strong authentication and secure encryption, authentication methods can use passwords, public keys, private keys, and HTTP channels. Direct Internet service provider connection. 3, Object designer Use professional object designer to create, modify, and design all database objects, such as: tables, views, functions, indexes, and triggers. No need to write complex SQL to create and edit objects. 4, Table Viewer view grid or form: Use the grid to view add, modify, and delete records. Browse the grid view with table-like features, such as sorting and hiding data groups, using the Navicat for PostgreSQL assistant editor: Remarks, hexadecimal, images or more, or view action records with forms, clearly displaying the field names and values of the records without fear of misinterpreting the data. Select foreign key data: Use foreign key relationships to select reference lookup tables and automatically create drop-down lists. Simplify workflows and improve efficiency by eliminating the need for constant reference to master tables. 5, SQL creation tools or editors SQL creation tools: Visual SQL creation tools create and edit queries or views without worrying about syntax and proper command usage. Select the operations that need to be performed in the table to automatically write SQL statements. Autocomplete code: Use Autocomplete code to quickly create SQL statements in the SQL editor. Whether you select the properties of the database object or SQL keywords, simply select from the drop-down list. 6, Database designer reverse engineering: Using Navicat for PostgreSQL reverse engineering, you can create a database model from an existing database, visually display and edit the database structure or create a graphical model, and generate a database from the model. Forward engineering and generate scripts: The Sync to database feature fully understands the differences in all databases and generates the necessary synchronization scripts to update the target database and make it identical to the model. Export SQL The opportunity to fully control the final SQL script, generate referential integrity rules, generate independent parts of the model, comments, character sets, etc., can greatly save work time. 7, Data processing tools Import or export wizard: Import data from files in different formats to tables, such as Access, Excel, XML, TXT, CSV, JSON and more. And after setting up the data source connection, you can import data from ODBC. Simply select the table you want to import, or specify the query using the Add Query button. Data can also be exported to various formats, such as Excel, TXT, CSV, DBF, XML, etc.

Installation tutorial

1. Run the software and install it according to the steps

2. After the installation is complete, copy patch. exe in navicat_patch 5.6 to the installation directory and run it as the administrator. Click the patch button, when cracked appears, click ok

3. Select PostgreSQL, as shown in the figure, and click generate

4, the generated registration serial number can be automatically filled in the software registration interface, appear √, click to activate

5, at this time will appear the following prompt, click manual activation manual activation

6. Copy the application code in the software to the corresponding position of the registration machine, and then click generate activation code, which will automatically fill in the activation code input box of the software. If it is not filled, copy and paste it manually

7. Click the activate button below, activate successfully, click ok

8. Activation is complete

Update log

Bug fix:

Minor bug fixes and improvements.