Generating SQL script for PostgreSQL

To generate SQL scripts from your PostgreSQL project click the SQL Script icon on the main toolbar. New modal opens. Click Save Script and select a location where the file should be stored.

Generating SQL script for PostgreSQL from an ER diagram

Generation settings

You can control how the script will be generated on the Generation settings tab

SQL script generation settings in PostgreSQL project

Order of items

The order in which the objects will be in the resulting SQL script can be modified on the Order items tab. You can easily change the order or click the Reset order button to automatically rearrange the positions of objects.

Order of objects for SQL script generation for PostgreSQL

Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.

#

DATA MODELING TOOLS
DRAW Diagrams and
GENERATE Scripts
Download data modeling tools
Blog Categories
Blog by Platforms