How can I retrieve unique values from a column with Knex.js?

Question

I use Knex.js to communicate to Postgres database.

I have rows in a table with a column named 'state' which represents a US state.

How can I retrieve all unique values from this column?

Answer 1

You are probably looking for knex.distinct + knex.pluck combo.

knex
    .distinct()
    .from('tablename')
    .pluck('state')
    .then(states => {
        console.log(states)
    })