migrat-postgres
The official PostgreSQL plugin for Migrat.
- Implements global locking.
- Implements global migration state storage, retrieval.
- Write migrations in pure PSQL.
$ npm install migrat-postgres --save
migrat.config.js
)
Configuration (var postgres = ; moduleexports = plugins: ;
Creating Migrations
$ migrat create <name> --type=psql
This will create a SQL file in the migrations directory that you can write normal SQL in. Just be sure to not remove the comments (they are used to pick out the queries):
-- up: ( id serial, username text); -- down: IF EXISTS user; -- check: SELECT EXISTS( SELECT * FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'user');
License
Copyright © 2014–2016 Natural Atlas, Inc. & Contributors
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at: http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.