PolarDB:Navicat Premium Lite

Prerequisites

• Your cluster runs the PolarDB for PostgreSQL (Compatible with Oracle) 2.0 database engine.

• A database account is created in the PolarDB cluster. For more information, see Create a database account.

• The endpoint and port used to connect to the cluster are obtained. For more information, see View endpoints and ports. To connect to the cluster over the Internet, you must first apply for a public endpoint.

• The IP address of the host that you use to access the PolarDB cluster is added to an IP address whitelist of the cluster. For more information, see Configure a whitelist for a cluster.

Download link

Navicat Premium Lite Community Edition

Usage notes

Install Navicat Premium Lite Community Edition

On the Navicat Premium Lite download page, select the version applicable to your operating system: macOS, Windows, or Linux. Follow the official installation instructions to install the selected version.

Configure the database

1. Configure the PolarDB for PostgreSQL (Compatible with Oracle) data source.

   1. Click Connection to create a connection.

      

   2. Select Alibaba Cloud > Alibaba Cloud PolarDB for PostgreSQL, and then click Next.

      

2. Configure the connection information of the PolarDB cluster.

   1. Configure the connection name, endpoint, port number, database name, account name, and password of the cluster. For information about how to view the connection information of a PolarDB cluster, see View endpoints and ports.

      

   2. Click Test Connection in the lower-left corner to test the network connection. If no issue exists, click OK to save the connection.

Test compatibility

Compared with PostgreSQL Community Edition, PolarDB for PostgreSQL (Compatible with Oracle) incorporates Oracle database features. Navicat Premium Lite is updated to work seamlessly with PolarDB for PostgreSQL (Compatible with Oracle). The following examples describe how Navicat Premium Lite is compatible with PolarDB for PostgreSQL (Compatible with Oracle).

64-bit DATE type

SELECT now()::date;

Sample result:

The default DATE type of PolarDB for PostgreSQL (Compatible with Oracle) includes not only the year, month, and day but also the time: hours, minutes, and seconds. The default DATE type of PostgreSQL contains only the year, month, and day.

Call Oracle-style Procedural Language (PL) anonymous block

DECLARE
 t2 int := 123456;
BEGIN
 DBMS_OUTPUT.PUT_LINE('test Navicat Premium Lite ' || t2);
END;

Sample result:

PolarDB for PostgreSQL (Compatible with Oracle) supports Oracle-style PL procedure calls. Navicat Premium Lite is updated to support the feature.

View the definitions of Oracle-style PL functions or stored procedures

You can use functions in Navicat Premium Lite to parse Oracle-style PL stored procedure definitions to assist your subsequent use of them.