pgpm-sql-conventions

Rules and format for writing SQL migration files in pgpm modules.

pgpm is deterministic — each change is deployed exactly once and reverted exactly once. Use CREATE, not CREATE OR REPLACE:

If you need to modify an existing function, create a new change that drops and recreates it, or use the revert/redeploy cycle.

pgpm 迁移脚本的 SQL 文件格式和约定。在编写部署/恢复/验证 SQL 文件时，当询问迁移文件格式、SQL 命名约定、依赖项声明或 pgpm 中的三文件模式时使用。 来源：constructive-io/constructive-skills。