Drizzle TeamDT
Drizzle Team•3y ago
Snoo

using postgres-js for connection

I am trying to setup drizzle with postgres-js package ( as document it be fastest). Referring to this doc:
https://orm.drizzle.team/docs/installation-and-db-connection/postgresql/postgresjs

How do i define schema using postgres-js ?? I tried import for table to my schema file and typescript shows error: Module '"drizzle-orm/postgres-js"' has no exported member ...

How can i import table and other types ?? shoud I use 'drizzle-orm/pg-core' package for schema and 'drizzle-orm/postgres-js' for my index.ts ??

schema.ts : 
import { integer, pgEnum, pgTable, serial, uniqueIndex, varchar,boolean,text,timestamp } from 'drizzle-orm/postgres-js';


index .ts :
import { drizzle, PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const connectionString = process.env.DATABASE_URL || "";

const queryClient = postgres(connectionString, { max: 10 });
const db: PostgresJsDatabase = drizzle(queryClient);
Was this page helpful?