Ulises Vargas De Sousa Ulises Vargas De Sousa - 1 year ago 230
Node.js Question

Node.js: Defining Postgres Schemas in Sequelize

The Official Documentation doesn't explains clearly how define schemas for database by themselves. I'm assuming that Sequelize is more related to MySql than Postgres (where schemas are mandatory).

If I've already created some schemas in Postgres, how I could sync them with Sequelize?

Answer Source

You can set the model with the schema using model.schema, something like:

var City = sequelize.define('City', {
    id: {
        type: sequelize.Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true,
        field: 'id'
    name: {
        type: sequelize.Sequelize.STRING,
        field: 'name'   
  }, {
    timestamps: false,
    tableName: 'cities'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download