Core concepts
Schema
pgTable
pgTable()
stable · v0.30+Defines a Postgres table — a typed schema that drives query inference, migrations, and your IDE's autocomplete. Compose columns with the column helpers in drizzle-orm/pg-core.
schema.ts
— Postgres
1
2
3
4
5
6
7
8
9
10
11
import { pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core' export const users = pgTable('users', { id: serial('id').primaryKey(), email: text('email').notNull().unique(), name: text('name'), createdAt: timestamp('created_at') .defaultNow().notNull(), })
Type inference — The column helpers carry through. users.id is typed as number, users.email as string. db.select().from(users) returns a typed row.