serial type invalid in psql

im trying to use serial type for my id column to enable auto-incremental id, but when migrating the schema it throws error saying

type "serial" doesnt exist

type "serial" doesnt exist

import { serial, boolean, text, pgTable } from "drizzle-orm/pg-core";

export const todos = pgTable("todos", {
  id: serial("id").primaryKey(),
  content: text("content").notNull(),
  completed: boolean("completed").default(false).notNull(),
});

import { serial, boolean, text, pgTable } from "drizzle-orm/pg-core";

export const todos = pgTable("todos", {
  id: serial("id").primaryKey(),
  content: text("content").notNull(),
  completed: boolean("completed").default(false).notNull(),
});

Drizzle Team•2y ago

advt

serial type invalid in psql

im trying to use serial type for my id column to enable auto-incremental id, but when migrating the schema it throws error saying

type "serial" doesnt exist

type "serial" doesnt exist

import { serial, boolean, text, pgTable } from "drizzle-orm/pg-core";

export const todos = pgTable("todos", {
  id: serial("id").primaryKey(),
  content: text("content").notNull(),
  completed: boolean("completed").default(false).notNull(),
});

import { serial, boolean, text, pgTable } from "drizzle-orm/pg-core";

export const todos = pgTable("todos", {
  id: serial("id").primaryKey(),
  content: text("content").notNull(),
  completed: boolean("completed").default(false).notNull(),
});

serial type invalid in psql

Similar Threads

serial type invalid in psql

Similar Threads

Similar Threads

Similar Threads