Do

1npm install @useverk/drizzle-pgvector

or

1yarn add @useverk/drizzle-pgvector

or

1pnpm add @useverk/drizzle-pgvector

And then in your code:

1import { customVector } from '@useverk/drizzle-pgvector'
2export const myTable = pgTable(
3  'mytable',
4  {
5    ...
6    embedding: customVector('embedding', { dimensions: 1536 }),
7    ...
8  })

Known issues

• running drizzle-kit generate will generate the following sql migration file:

  1CREATE TABLE IF NOT EXISTS "myTable" (
  2"id" serial PRIMARY KEY NOT NULL,
  3"vector" "vector(1536)"
  4);

  which is not valid postgresql syntax. Simply remove the quotes around the type name to fix it. The correct syntax is:

  1CREATE TABLE IF NOT EXISTS "myTable" (
  2"id" serial PRIMARY KEY NOT NULL,
  3"vector" vector(1536)
  4);

  Will fix this once drizzle-kit is open-source.