Framework and utilities to upgrade and maintain databases
Pyrseas currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification.
Pyrseas is distributed under the BSD license.
In a hurry? Add it to your Download Basket!
What's New in version 0.6.0
- This version supports the following additional DDL features: EXTENSIONs, COLLATIONs, OWNER information, access privileges (GRANT and REVOKE), TABLESPACEs for tables, primary keys and indexes, MATCH attributes for foreign keys, ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE, ENUMs with no labels, UNLOGGED tables, and the CREATE FUNCTION SET configuration_parameter. It also support PostgreSQL 9.2.