Prev Next

Create a PostgreSQL Repository

Creating a PostgreSQL database is fully documented in the product information provided with your PostgreSQL installer.

There are many ways to create a new PostgreSQL database. A common method is to use an SQL-based Management Console such as pgAdmin, which provides a convenient graphical user interface for creating databases, executing scripts, and performing backups and restores.  However, the exact method used is not important to this discussion, and you can use the most convenient or familiar method at your disposal.

Having created your PostgreSQL database, use the SQL script provided by Sparx Systems to create the required table definitions for Enterprise Architect. The EASchema_1220_PostgreSQL.sql script is freely available on the DBMS Based Repositories page on the Sparx Systems website.

Notes

  • Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic

Learn more