Node.js: Defining Postgres Schemas in Sequelize

Question

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?

I think you need to recreate the models using sequelize before you can sync. There was a project I saw that generated models from an existing db (SQL Server(?)) but it didn't work very well for me. — Mike Cheel
– Mike Cheel, Commented Sep 19, 2016 at 19:58
I can recreate the models (tables) perfectly with Sequelize. My issue are the Postgres Schemas (public, security, audit, whatever...), that I've created in Postgres. These schemas will contain the models (tables), but for themselves I don't know how sync them with Sequelize. — Ulises Vargas De Sousa
– Ulises Vargas De Sousa, Commented Sep 19, 2016 at 20:06

BrTkCa · Accepted Answer · 2016-09-19 20:19:19Z

4

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'
    });
City.schema("public");

edited Sep 19, 2016 at 20:19

answered Sep 19, 2016 at 20:11

BrTkCa

4,7934 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Mike Cheel Over a year ago

I think you meant City.schema("public")

Mike Cheel Over a year ago

I figured but JavaScript doesn't know that!

Ulises Vargas De Sousa Over a year ago

Thank you so much! It is just all want!

Ulises Vargas De Sousa Over a year ago

And also, this answer is valid to me: stackoverflow.com/a/32025860/6291719

BrTkCa Over a year ago

Nice, this is the way

|

Collectives™ on Stack Overflow

Node.js: Defining Postgres Schemas in Sequelize

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related