note

Appearance

索引 ​

index ​

ts
export const user = pgTable(
  "user",
  {
    id: serial("id").primaryKey(),
    name: text("name"),
    email: text("email"),
  },
  (table) => [index("name_idx").on(table.name)]
);

unique index ​

ts
export const user = pgTable(
  "user",
  {
    id: serial("id").primaryKey(),
    name: text("name"),
    email: text("email"),
  },
  (table) => [uniqueIndex("email_idx").on(table.email)]
);