In this chapter, we covered the basic steps to be followed to design tables using SQL Power Architect. We also saw how to make changes and generate SQL to be applied to an existing database to sync it with the data model. Also, we covered the export options available for the data model. We also saw that we can profile an existing database with Power Architect.
In the next chapter, we will cover two client tools that can be used to work with a PostgreSQL database: pgAdmin3 and psql.