knex.js + pg specify varchar to be > 255

node.js postgresql knex.js
kuanb picture kuanb · Mar 5, 2016 · Viewed 8k times · Source

When creating a table in knex migrations, I have indicated a col as such:

table.string("content");

It defaults to varchar 255. I would like it to be able to hold more text. How do I indicate to knex that I want this to occur?

Answer

Sanjeev Kumar Pandit picture Sanjeev Kumar Pandit · Aug 16, 2016

You can define the col in following way to set the length of the string:

    table.string("content", 1000)

This results to:

    content         character varying(1000)

Reference: http://knexjs.org/#Schema-string

Related questions

Knex primary key auto increment

I'm using knex to create a simple table in postgres database: function up(knex, Promise) { return knex.schema.createTableIfNotExists('communities', (table) => { table.increments('id').primary().unsigned(); table.string('name', 255).notNullable(); table.string('slug', 100).notNullable(); table.timestamp('createdAt').defaultTo( knex.…

Read More
knex: what is the appropriate way to create an array from results?

I have an endpoint that joins the user and user_emails table as a one-to-many relationship (postgresql). It look as follows. router.get('/', function (req, res, next) { db.select('users.id', 'users.name', 'user_emails.address') .from('users') .…

Read More
Ignore error in batch insert Postgresql

I have a process that runs every 5 minutes and tries to insert a batch of articles into a table. The articles come from web-scrapping, so there are cases in which I am trying to insert a batch that contains articles …

Read More