/postgres-schema-updater

This npm cli module will detect changes in your schema, and apply them to your database

Primary LanguageTypeScriptMIT LicenseMIT

### How to use

you can configure parameters with a .env file or via env variable.

The .env file could have contents like:
```
CONNECTION_STRING=postgres://admin:1234@localhost:5432/apidb
SOURCE=sql/src/**/*sql
TMP_FILE=sql/development.sql
COMPARE_FILE=sql/staging.sql
```

```
cd  example
node ../bin/stage.js -v -c "postgres://postgres@localhost:5432/YOUR_DB"
```

or add "my-stage": "stage" to your scripts section of the package.json file and call stage like:

```
npm run my-stage -- -v -c "postgres://postgres@localhost:5432/YOUR_DB
```

You will be asked before anything is performed on the database.