Database Designer for PostgreSQL supports the following database related functions:
New Database Wizard, that allows you to create a new physical database;
Database Generation, that allows to generate SQL script, that represents the diagram you developed and executes it on the database server;
Database Modification, that allows to generate SQL script that leads your database to the current state of your diagram.