**pgCompare Community** helps you stay in control of schema changes across development, test, and production environments. pgCompare offers a fast, reliable way to compare PostgreSQL database schemas and deploy changes safely and efficiently.
## Key Features **Object-by-Object Comparison** Tables, views, functions, sequences, indexes, triggers, constraints, procedures, and more. **Auto-Generated SQL Scripts** Automatically handles object dependencies for smooth deployments. **Risk Warnings** Alerts for potentially dangerous operations like column drops or table truncations. **Targeted Deployment** Deploy specific objects without affecting the entire schema. **Visual Diff Interface** Easily spot differences with a clear, intuitive UI. **PostgreSQL Version Support** Compatible with PostgreSQL **v9 through the latest release**. ## Licensing Terms pgCompare Community is **free** for: - Small businesses and individuals (less than $1 million in annual revenue) - Educational use (students and educators) - Non-commercial open source projects ## Useful Links - 📥 [Download pgCompare](https://www.red-gate.com/products/redgate-pgcompare/) - 📚 [Read the Documentation](https://documentation.red-gate.com/pgc)
