Pyrseas includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables.
A similar, yet reverse tool, yamltodb, generates SQL statements to modify a database to match an inputted YAML file.
This way database setups can be easily migrated or upgraded via one single YAML file.
If various iterations of a YAML file are kept, than a basic database versioning system is created, which developers can use to go back and forward between various database states.
This can be useful in both development and production environments.
- Added support for MATERIALIZED VIEWs, EVENT TRIGGERs, CLUSTER, configuration files, multiple-file input or output, data export and import and more.