Pyrseas provides utilities to describe a PostgreSQL database schema as YAML, to verify the schema against the same or a different database and to generate SQL that will modify the schema to match the YAML description.
- Outputs a YAML/JSON description of a PostgreSQL database’s tables and other objects (metadata), suitable for storing in a version control repository
- Generates SQL statements to modify a database so that it willl match an input YAML/JSON specification
- Generates an augmented YAML description of a PostgreSQL database from its catalogs and an augmentation specification.
- Configuration Items
- Known Issues
- Predefined Database Augmentations
- Event Triggers
- Foreign Data Objects
- Procedural Languages
Functions, Operators and Triggers¶
Types and Other Schema Objects¶
- Text Search Objects
- Types and Domains