Alatar is an experimental project to analyze dependencies between the entities of a PostgreSQL schema.
The project don't use PostgreSQL parser to extract informations from the database schema. You must only give to him a structure only dump file. The table below lists the SQL objects that are managed by Alatar. A star icon indicates that the object is already supported.
| SQL Object | Status |
|---|---|
| Extension | ⭐ |
| Schema | public schema only |
| Table | ⭐ |
| Inherited table | ⭐ |
| Foreign table | |
| View | ⭐ |
| Column | ⭐ |
| Data type | ⭐ |
| Enumeration | |
| Composite type | |
| Unique constraint | ⭐ |
| Primary Key constraint | ⭐ |
| Foreign Key constraint | ⭐ |
| Not Null constraint | ⭐ |
| Default constraint | |
| Inherited constraint | ⭐ |
| Check constraint | ⭐ |
| PL/pgSQL function | ⭐ |
| Comment | ⭐ |
| Rule | ⭐ |
| Sequence | ⭐ |
| Trigger | ⭐ |
| SQL request |
Alatar builds a model from the database schema. You can study it with the request API. If you are not a Perl programmer, you can also save the model with a XML exporter and use your tools to extract what you want.