How do I define Sequelize.STRING length?

node.js postgresql string-length sequelize.js
gusera2334967 picture gusera2334967 · Apr 30, 2013 · Viewed 32k times · Source

I want to define a length of a datatype in sequelize. There is my source code :

var Profile = sequelize.define('profile', {
  public_id: Sequelize.STRING,
  label: Sequelize.STRING
})

It create a table profiles with a public_id with a datatype varchar(255).

I would like to define a public_id with varchar(32).

I searched on the doc and the stack but couldn't find any answer...

How can I do that please ?

Answer

Szymon Wygnański picture Szymon Wygnański · Oct 13, 2013

As it is mentioned in the documentation, use:

Sequelize.STRING(32)

Related questions

What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
How to make connection to Postgres via Node.js

I find myself trying to create a postgres database, so I installed postgres and started a server with initdb /usr/local/pgsql/data, then I started that instance with postgres -D /usr/local/pgsql/data now how can I interact …

Read More
What is the proper way to use the node.js postgresql module?

I am writing a node.js app on Heroku and using the pg module. I can't figure out the "right" way to get a client object for each request that I need to query the database. The documentation uses code …

Read More