Back to Drizzle Orm

CreateTable

src/mdx/get-started/postgresql/CreateTable.mdx

latest426 B
Original Source

Create a schema.ts file in the src/db directory and declare your table:

typescript
import { integer, pgTable, varchar } from "drizzle-orm/pg-core";

export const usersTable = pgTable("users", {
  id: integer().primaryKey().generatedAlwaysAsIdentity(),
  name: varchar({ length: 255 }).notNull(),
  age: integer().notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});