node-pg-migrate
Node.js database migration management for PostgreSQL
File Explorer
Download Latest Version (.zip)- bug_report.yml
- feature_request.yml
- ci.yml
- cockroach-test.yml
- coverage-report.yml
- coverage.yml
- docs.yml
- postgres-test.yml
- publish.yml
- semantic-pull-request.yml
- CODEOWNERS
- renovate.json5
- extensions.json
- settings.json
- index.ts
- style.css
- config.mts
- troubleshooting.md
- typescript.md
- casts.md
- columns.md
- constraints.md
- domains.md
- extensions.md
- functions.md
- grants.md
- index.md
- indexes.md
- misc.md
- mViews.md
- operators.md
- policies.md
- roles.md
- schemas.md
- sequences.md
- tables.md
- triggers.md
- types.md
- views.md
- api.md
- cli.md
- getting-started.md
- index.md
- introduction.md
- migration-loading-strategies.md
- upgrading.md
- tsconfig.json
- args.ts
- commands.ts
- config.ts
- index.ts
- options.ts
- createCast.ts
- dropCast.ts
- index.ts
- alterDomain.ts
- createDomain.ts
- dropDomain.ts
- index.ts
- renameDomain.ts
- shared.ts
- createExtension.ts
- dropExtension.ts
- index.ts
- shared.ts
- createFunction.ts
- dropFunction.ts
- index.ts
- renameFunction.ts
- shared.ts
- grantOnSchemas.ts
- grantOnTables.ts
- grantRoles.ts
- index.ts
- revokeOnSchemas.ts
- revokeOnTables.ts
- revokeRoles.ts
- shared.ts
- createIndex.ts
- dropIndex.ts
- index.ts
- renameIndex.ts
- shared.ts
- alterMaterializedView.ts
- createMaterializedView.ts
- dropMaterializedView.ts
- index.ts
- refreshMaterializedView.ts
- renameMaterializedView.ts
- renameMaterializedViewColumn.ts
- shared.ts
- addToOperatorFamily.ts
- createOperator.ts
- createOperatorClass.ts
- createOperatorFamily.ts
- dropOperator.ts
- dropOperatorClass.ts
- dropOperatorFamily.ts
- index.ts
- removeFromOperatorFamily.ts
- renameOperatorClass.ts
- renameOperatorFamily.ts
- shared.ts
- alterPolicy.ts
- createPolicy.ts
- dropPolicy.ts
- index.ts
- renamePolicy.ts
- shared.ts
- alterRole.ts
- createRole.ts
- dropRole.ts
- index.ts
- renameRole.ts
- shared.ts
- createSchema.ts
- dropSchema.ts
- index.ts
- renameSchema.ts
- alterSequence.ts
- createSequence.ts
- dropSequence.ts
- index.ts
- renameSequence.ts
- shared.ts
- addColumns.ts
- addConstraint.ts
- alterColumn.ts
- alterTable.ts
- createTable.ts
- dropColumns.ts
- dropConstraint.ts
- dropTable.ts
- index.ts
- renameColumn.ts
- renameConstraint.ts
- renameTable.ts
- shared.ts
- createTrigger.ts
- dropTrigger.ts
- index.ts
- renameTrigger.ts
- shared.ts
- addTypeAttribute.ts
- addTypeValue.ts
- createType.ts
- dropType.ts
- dropTypeAttribute.ts
- index.ts
- renameType.ts
- renameTypeAttribute.ts
- renameTypeValue.ts
- setTypeAttribute.ts
- alterView.ts
- alterViewColumn.ts
- createView.ts
- dropView.ts
- index.ts
- renameView.ts
- shared.ts
- generalTypes.ts
- sql.ts
- comparators.ts
- createSchemalize.ts
- createTransformer.ts
- decamelize.ts
- escapeValue.ts
- fileNameUtils.ts
- formatLines.ts
- formatParams.ts
- formatPartitionColumns.ts
- formatSql.ts
- getMigrationTableSchema.ts
- getSchemas.ts
- identity.ts
- index.ts
- intersection.ts
- makeComment.ts
- PgLiteral.ts
- quote.ts
- stringIdGenerator.ts
- toArray.ts
- types.ts
- db.ts
- index.ts
- logger.ts
- migration.ts
- migrationBuilder.ts
- migrationLoader.ts
- migrationOptions.ts
- pgType.ts
- runner.ts
- sqlMigration.ts
- migration-template.cjs
- migration-template.cts
- migration-template.js
- migration-template.mjs
- migration-template.mts
- migration-template.sql
- migration-template.ts
- migrationBuilder.spec.ts.snap
- 004_table.js
- 006_table_rename.js
- 008_column_drop.js
- 009_column.js
- 011_column_rename.js
- 012_column_alter.js
- 014_add_constraint.js
- 017_drop_constraint.js
- 019_add_index.js
- 020_create_index.js
- 062_view.js
- 062_view_test.js
- migrations-down.pg-14.stdout.log
- migrations-down.pg-15.stdout.log
- migrations-down.pg-16.stdout.log
- migrations-down.pg-17.stdout.log
- migrations-down.pg-18.stdout.log
- migrations-down.stderr.log
- migrations-up.pg-14.stdout.log
- migrations-up.pg-15.stdout.log
- migrations-up.pg-16.stdout.log
- migrations-up.pg-17.stdout.log
- migrations-up.pg-18.stdout.log
- migrations-up.stderr.log
- db-config-it.spec.ts
- utils.ts
- invalid-prefix.js
- 1-test-migration.js
- 1-test-migration.mjs
- 1-test-migration.mts
- 1-test-migration.ts
- columns.ts
- 1-with-alias.ts
- 1-with-alias.ts
- tsconfig.json
- jiti.spec.ts
- tsconfig-paths.spec.ts
- 001_nested_noop.js
- 001_noop.js
- 002_callback.js
- 003_promise.js
- 004_table.js
- 005_table_test.js
- 006_table_rename.js
- 007_table_rename_test.js
- 008_column_drop.js
- 009_column.js
- 010_column_test.js
- 011_column_rename.js
- 012_column_alter.js
- 013_column_alter_test.js
- 014_add_constraint.js
- 015_add_constraint_test.js
- 016_rename_constraint.js
- 017_drop_constraint.js
- 018_drop_constraint_test.js
- 019_add_index.js
- 020_drop_index.js
- 021_add_type.js
- 022_add_type_test.js
- 023_add_type_attribute.js
- 024_add_type_attribute_test.js
- 025_set_type_attribute.js
- 026_set_type_attribute_test.js
- 027_add_type_value.js
- 028_add_type_value_test.js
- 029_rename_type_attribute.js
- 030_rename_type_attribute_test.js
- 031_drop_type_attribute.js
- 032_drop_type_attribute_test.js
- 033_drop_type.js
- 034_drop_type_test.js
- 035_role_add.js
- 036_role_alter.js
- 037_role_rename.js
- 038_role_drop.js
- 039_function_create.js
- 040_function_rename.js
- 041_function_test.js
- 042_function_drop.js
- 043_trigger_create_rename.js
- 044_trigger_test.js
- 045_trigger_drop.js
- 046_domain_create_rename.js
- 047_domain_check.js
- 048_domain_drop.js
- 049_sequence_create_rename.js
- 050_sequence_test.js
- 051_sequence_alter.js
- 052_sequence_alter_test.js
- 053_sequence_drop.js
- 054_operator_create.js
- 055_operator_test.js
- 056_operator_drop.js
- 057_policy_create.js
- 058_policy_test.js
- 059_policy_drop.js
- 060_column_comment.js
- 061_column_comment_test.js
- 062_view.js
- 063_view_test.js
- 064_alter_view_column.js
- 065_materialized_view.js
- 066_materialized_view_test.js
- 067_materialized_view_alter.js
- 068_extension.js
- 069_comments.js
- 070_extension_schema.js
- 071_constraint_name_for_foreign_key.js
- 072_alter_column_comment.js
- 073_alter_column_comment_test.js
- 074_rename_type_value.js
- 075_drop_index_schema.js
- 076_create_table_like.js
- 077_create_table_generated_column.js
- 078_add_column_if_not_exists.js
- 079_drop_index_schema.js
- 080_create_table_generated_column_take_2.js
- 081_temporary_table.js
- 082_view_options.js
- 083_alter_column_sequence.js
- 084_drop_unique_index.js
- 085_grant_tables_schemas_roles.js
- 086_grant_test.js
- 087_revoke_tables_schemas_roles.js
- 088_revoke_test.js
- 089_grant_reverse.js
- 090_create_cast.js
- 091_function_set.js
- 092_partition.js
- 093_alter_column_expression.js
- 094_unlogged_table.js
- 095_index_nulls.js
- 096_expression_index.js
- 097_drop_constraint_if_table_exists.js
- 098_rename_index.js
- createCast.spec.ts
- dropCast.spec.ts
- addColumns.spec.ts
- alterColumn.spec.ts
- dropColumns.spec.ts
- renameColumn.spec.ts
- addConstraint.spec.ts
- dropConstraint.spec.ts
- renameConstraint.spec.ts
- alterDomain.spec.ts
- createDomain.spec.ts
- dropDomain.spec.ts
- renameDomain.spec.ts
- createExtension.spec.ts
- dropExtension.spec.ts
- createFunction.spec.ts
- dropFunction.spec.ts
- renameFunction.spec.ts
- grantOnSchemas.spec.ts
- grantOnTables.spec.ts
- grantRoles.spec.ts
- revokeOnSchemas.spec.ts
- revokeOnTables.spec.ts
- revokeRoles.spec.ts
- createIndex.spec.ts
- dropIndex.spec.ts
- renameIndex.spec.ts
- alterMaterializedView.spec.ts
- createMaterializedView.spec.ts
- dropMaterializedView.spec.ts
- refreshMaterializedView.spec.ts
- renameMaterializedView.spec.ts
- renameMaterializedViewColumn.spec.ts
- addToOperatorFamily.spec.ts
- createOperator.spec.ts
- createOperatorClass.spec.ts
- createOperatorFamily.spec.ts
- dropOperator.spec.ts
- dropOperatorClass.spec.ts
- dropOperatorFamily.spec.ts
- removeFromOperatorFamily.spec.ts
- renameOperatorClass.spec.ts
- renameOperatorFamily.spec.ts
- alterPolicy.spec.ts
- createPolicy.spec.ts
- dropPolicy.spec.ts
- renamePolicy.spec.ts
- alterRole.spec.ts
- createRole.spec.ts
- dropRole.spec.ts
- renameRole.spec.ts
- createSchema.spec.ts
- dropPolicy.spec.ts
- renameSchema.spec.ts
- alterSequence.spec.ts
- createSequence.spec.ts
- dropSequence.spec.ts
- renameSequence.spec.ts
- alterTable.spec.ts
- createTable.spec.ts
- dropTable.spec.ts
- renameTable.spec.ts
- createTrigger.spec.ts
- dropTrigger.spec.ts
- renameTrigger.spec.ts
- addTypeAttribute.spec.ts
- addTypeValue.spec.ts
- createType.spec.ts
- dropType.spec.ts
- dropTypeAttribute.spec.ts
- renameType.spec.ts
- renameTypeAttribute.spec.ts
- renameTypeValue.spec.ts
- setTypeAttribute.spec.ts
- alterView.spec.ts
- alterViewColumn.spec.ts
- createView.spec.ts
- dropView.spec.ts
- renameView.spec.ts
- sql.spec.ts
- 1-test-migration.ts
- 2-test-migration.ts
- customRunner.ts
- customRunnerDBClient.ts
- customRunnerDBUrl.ts
- customRunnerUndefCount.ts
- comparators.spec.ts
- createSchemalize.spec.ts
- createTransformer.spec.ts
- decamelize.spec.ts
- escapeValue.spec.ts
- fileNameUtils.spec.ts
- formatLines.spec.ts
- formatParam.spec.ts
- formatSql.spec.ts
- getMigrationTableSchema.spec.ts
- getSchemas.spec.ts
- isPgLiteral.spec.ts
- makeComment.spec.ts
- StringIdGenerator.spec.ts
- toArray.spec.ts
- types.spec.ts
- 1414549381268_names.js
- 1414549381268_names_promise.js
- 1739900132875_names_reversed.js
- db.spec.ts
- migration.spec.ts
- migrationBuilder.spec.ts
- migrationLoader.spec.ts
- presetMigrationOptions.ts
- runner.loadMigrations.regression.spec.ts
- runner.spec.ts
- sqlMigration.spec.ts
- .editorconfig
- .gitattributes
- .gitignore
- .npmrc
- .oxfmtrc.json
- .oxlintrc.json
- CHANGELOG.md
- LICENSE
- package.json
- pnpm-lock.yaml
- pnpm-workspace.yaml
- README.md
- tsconfig.json
- tsdown.config.ts
- vitest.config.ts
# Installation Guide
1. Get the code
git clone https://github.com/salsita/node-pg-migrate
Downloads the entire project code from GitHub to your computer.
cd node-pg-migrate
Moves into the project folder you just downloaded.
2. Node.js
Easy RecommendedPrerequisites
npm add pg
Type this command into your terminal and run it.
npm add --save-dev node-pg-migrate
Type this command into your terminal and run it.
After running the command, open the address shown in the terminal (usually something like http://localhost:3000) in your browser.
Pulled directly from this repo's README.
// repository documentation
Was this content helpful?
(0 ratings)