To generate SQL scripts from your PostgreSQL project, click the SQL Script icon on the main toolbar. A new modal opens. Click Save Script and select a location where the file should be stored.
You can execute the generated SQL in one of the following top 5 GUI tools for PostgreSQL.
Generation settings
You can control how the script will be generated on the Generation settings tab
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 rearrange the positions of objects automatically.
The option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.
#
