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。