I am proud to announce the first public release of pgquarrel.
pgquarrel compares PostgreSQL database schemas and outputs a set of
commands to turn a database schema into another one. The main use case
is to deploy database changes into testing, staging or production
environments.
pgquarrel is written in C and doesn't rely on another tools. It could
work with different PostgreSQL versions. It covers almost all supported
objects (24 of 33). It is licensed under the PostgreSQL license.
* Website: http://eulerto.github.io/pgquarrel
* GitHub: https://github.com/eulerto/pgquarrel
Download
---------
https://github.com/eulerto/pgquarrel/releases
Features
---------
pgquarrel supports the following objects (partial or complete):
- AGGREGATE
- CAST
- COMMENT
- CONVERSION
- DOMAIN
- EVENT TRIGGER
- EXTENSION
- FUNCTION
- INDEX
- LANGUAGE
- MATERIALIZED VIEW
- RULE
- SCHEMA
- SEQUENCE
- TABLE
- TRIGGER
- TYPE
- VIEW
- GRANT
- REVOKE
- SECURITY LABEL
- FOREIGN DATA WRAPPER
- SERVER
- USER MAPPING
Future Work
------------
- rename objects
- switch object schema
- roles
- tablespaces
- inheritance
- foreign table
- text search
- collation
- operator
- Windows support
Issues
-------
Report issues at https://github.com/eulerto/pgquarrel/issues
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento