PostgreSQL Schema
PostgreSQL Schema is a database migration tool. Based on Schema Evolution Manager.
Installation
The tools can be installed through cabal or stack.
Cabal:
$ cabal install postgresql-schema
Stack:
$ git clone git@github.com:mfine/postgresql-schema.git
$ cd postgresql-schema
$ stack install
Adding Migrations
Add a migration file. The tool schema-add takes as parameters a file
and a directory containing migrations. By default, the directory
migrations in the current working directory is used. These
parameters can be overridden on the command line:
$ schema-add --file new.sql --name add-users --dir scripts
Applying Migrations
Apply migrations to a database. The tool schema-apply takes as
parameters a database and a directory containing migrations. By
default, the directory migrations in the current working directory
is used, and the database specified in DATABASE_URL environment
variable is used. These parameters can be overridden on the command
line:
$ schema-apply --url postgres://user@localhost/database --dir scripts
Clearing Migrations
Remove public and migrations schema from a database - USE
CAREFULLY. The tool schema-clear takes as paramaters a
database. By default, the database specified in DATABASE_URL
environment variable is used. This parameter can be overriden on the
command line:
$ schema-clear --url postgres://user@localhost/database