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](https://www.datensen.com/blog/wp-content/uploads/generating-sql-postgresql.webp)
Generation settings
You can control how the script will be generated on the Generation settings tab
![SQL script generation settings in PostgreSQL project](https://www.datensen.com/blog/wp-content/uploads/generation-settings-postgres.webp)
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](https://www.datensen.com/blog/wp-content/uploads/generation-sql-for-postgresql-order-items.webp)
Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.
#