What is the numeric type equivalent in KnexJS (Postgres)?

Question

I am creating a table using Knex.JS, and the table has a column for a currency value.

For example, here is the column amount:

knex.schema.createTable('payment', function(table) {
  table.increments();
  table.float('amount');
})

Currently, I am using the float type, but I'd like to use the numeric type. What is the equivalent of the numeric type in Knex.JS?

Thanks.

flaviodesousa · Accepted Answer · 2016-05-06 21:11:29Z

16

For currency decimal is best match, so your code may look like:

knex.schema.createTable('payment', function(table) {
  table.increments();
  table.decimal('amount',14,2); // e.g. 14 positions, 2 for the cents
});

see http://knexjs.org/#Schema-decimal

answered May 6, 2016 at 21:11

flaviodesousa

8,0254 gold badges30 silver badges35 bronze badges

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

1 Comment

Matt Sanders Over a year ago

I was confused about this as well. From the postgres docs: "The types decimal and numeric are equivalent. Both types are part of the SQL standard."

Collectives™ on Stack Overflow

What is the numeric type equivalent in KnexJS (Postgres)?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related