Writing SQL queries with Schema Compare for PostgreSQL

Last modified: June 26, 2023

dbForge Schema Compare for PostgreSQL allows writing and executing SQL statements.

To create a new SQL query click New SQL in the menu ribbon.

Postgres Schema Diff - New SQL query

The SQL editor will be displayed.

Postgres Schema Compare - SQL editor

When you type text in SQL editor, it automatically recognizes and highlights SQL syntax.

For ease of SQL writing and reviewing, you can also use such supported shortcut keys as: CTRL+PLUS (+) KEY (to zoom the query in), CTRL+MINUS (-) KEY (to zoom the query out), and CTRL+0 (to return an SQL document to the one-to-one scale).

You can write and execute SQL queries not only by one at a time but you may compose SQL scripts as well. SQL scripts consist of multiple SQL statements separated by the appropriate statement delimiter.