@sql-extra/createindex v0.1.3

@sql-extra/createindex

Generate SQL command for CREATE INDEX.

const createIndex = require('@sql-extra/createindex');
// createIndex(<name>, <table>, <expression>, [options])
// -> sql command

// options: {
//   method: null  // index method: btree
// }


createIndex('food_code_idx', 'food', `"code"`);
// CREATE INDEX IF NOT EXISTS "food_code_idx" ON "food" ("code");

createIndex('food_type_idx', 'food', `"type"`, {method: 'GIN'});
// CREATE INDEX IF NOT EXISTS "food_type_idx" ON "food" USING GIN ("type");