7 replies

Unique key in PG

Hey guys, sorry I have a little dumb question here

I wanna know how to set my id field in my PG to auto increament.

Here's my schema;

const apiInventory = pgTable("api_inventory", {
  id: serial("id").primaryKey(), //I want this to auto-increament.
  // other columns and field here...
  status: text("status").notNull(),
  created_at: timestamp("created_at").defaultNow().notNull(),
  last_modified: timestamp("last_modified").defaultNow().notNull(),
});

const apiInventory = pgTable("api_inventory", {
  id: serial("id").primaryKey(), //I want this to auto-increament.
  // other columns and field here...
  status: text("status").notNull(),
  created_at: timestamp("created_at").defaultNow().notNull(),
  last_modified: timestamp("last_modified").defaultNow().notNull(),
});

Someone look this up please, not sure I've found the right docs yet.

Drizzle Team•2y ago•

7 replies

master_codes22

Unique key in PG

Hey guys, sorry I have a little dumb question here

I wanna know how to set my id field in my PG to auto increament.

Here's my schema;

const apiInventory = pgTable("api_inventory", {
  id: serial("id").primaryKey(), //I want this to auto-increament.
  // other columns and field here...
  status: text("status").notNull(),
  created_at: timestamp("created_at").defaultNow().notNull(),
  last_modified: timestamp("last_modified").defaultNow().notNull(),
});

const apiInventory = pgTable("api_inventory", {
  id: serial("id").primaryKey(), //I want this to auto-increament.
  // other columns and field here...
  status: text("status").notNull(),
  created_at: timestamp("created_at").defaultNow().notNull(),
  last_modified: timestamp("last_modified").defaultNow().notNull(),
});

Someone look this up please, not sure I've found the right docs yet.

Unique key in PG

Similar Threads

Unique key in PG

Similar Threads

Similar Threads

Similar Threads