Procedures / Functions 58 Packages 59 Recycle Bin 60 Other Objects 61 Maintain Objects 61 PostgreSQL 64 Databases & Schemas 64 Tables 64 Views 65 Materialized Views 66 Procedures / in Non-Essentials Edition) 157 5 About Debugger 157 Oracle PL/SQL Debugger 157 PostgreSQL PL/pgSQL Debugger 158 Chapter 10 - Pub/Sub (Available only in Non-Essentials Edition) 161 Job (Step 2) 262 Chapter 15 - Backup & Restore 264 About Backup & Restore 264 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 264 About Built-in Backup & Restore

Procedures / Functions 57 Packages 58 Recycle Bin 59 Other Objects 60 Maintain Objects 60 PostgreSQL 62 Databases & Schemas 62 Tables 63 Views 64 Materialized Views 64 Procedures / in Non-Essentials Edition) 156 5 About Debugger 156 Oracle PL/SQL Debugger 156 PostgreSQL PL/pgSQL Debugger 157 Chapter 10 - Pub/Sub (Available only in Non-Essentials Edition) 160 Job (Step 2) 261 Chapter 15 - Backup & Restore 263 About Backup & Restore 263 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 263 About Built-in Backup & Restore

Procedures / Functions 57 Packages 58 Recycle Bin 59 Other Objects 60 Maintain Objects 60 PostgreSQL 62 Databases & Schemas 62 Tables 63 Views 64 Materialized Views 64 Procedures / in Non-Essentials Edition) 153 5 About Debugger 153 Oracle PL/SQL Debugger 153 PostgreSQL PL/pgSQL Debugger 154 Chapter 10 – Pub/Sub (Available only in Non-Essentials Edition) 156 Job (Step 2) 267 Chapter 15 - Backup & Restore 268 About Backup & Restore 268 MySQL / PostgreSQL / SQLite / MariaDB (Available only in Non-Essentials Edition) 268 About Built-in Backup & Restore

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

Supported On-Premises Databases • MySQL 3.23 or later, Drizzle, OurDelta, Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later Amazon Redshift • Amazon Aurora for MySQL • Amazon Aurora for PostgreSQL • Amazon RDS for MySQL • Amazon RDS for PostgreSQL • Amazon RDS for Oracle • Amazon RDS for SQL Server • Amazon Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud • Oracle Database Cloud Service • Oracle

conceptual/logical/physical models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud Release 2, 11g Release 1, 11g Release 2, 12c Release 1, 12c Release 2, 18c, 19c, 21c, 23c • PostgreSQL - 7.3, 7.4, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10.0, 11.0, 12.0, 13.0 optional. Limit Specify the number of records to be displayed. Note: Available only for MySQL, PostgreSQL, SQLite and MariaDB. Add Expressions/Subqueries You can add an expression or a subquery to

conceptual/logical/physical models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud Release 2, 11g Release 1, 11g Release 2, 12c Release 1, 12c Release 2, 18c, 19c, 21c, 23c • PostgreSQL - 7.3, 7.4, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6, 10.0, 11.0, 12.0, 13.0 optional. Limit Specify the number of records to be displayed. Note: Available only for MySQL, PostgreSQL, SQLite and MariaDB. Add Expressions/Subqueries You can add an expression or a subquery to

Supported Repository Databases 13 • MySQL 5.1.73 or later • MariaDB 10.0 or later • PostgreSQL 9.5.1 or later • SQL Server 2012 or later • Amazon RDS Instance Offline Installation all user information and Navicat objects. It can be either a MySQL database, MariaDB database, PostgreSQL database, SQL Server database or Amazon RDS instance. We do not recommend setting the repository existing database or a new database created by Navicat On-Prem Server. Schema Name [SQL Server / PostgreSQL] The name of the schema. Domain [SQL Server] The domain name of the database server. 19