Drizzle Team•9mo ago

introspect not finding tables for pg database

Hi all. Contributing to an OSS project https://github.com/codu-code/codu and we are migrating from prisma to drizzle. We have built the drizzle schema manually but its not 100% correct as we are having issues migrating some of our DB queries. Ideally we would like to have drizzle kit create the schema definition for us using

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

However when we run this, it ignores the tables and only pulls the enums from our PG DB and not the tables. This creates the following schema

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

import { pgTable } from "drizzle-orm/pg-core"
  import { sql } from "drizzle-orm"

export const role = pgEnum("Role", ['MODERATOR', 'ADMIN', 'USER'])

We have 17 tables in our DB and would like these and there relations to be pulled into the schema file. Repro Steps 1. mkdir codu 2. cd codu 3. git clone https://github.com/codu-code/codu.git 4. Run

npm i

npm i

5. Look at the README to learn our to populate the .env file. The sample.env will give you the DB creds you need. Just rename it from sample.env -> .env 6. Run

docker compose up

docker compose up

7. Run

npx prisma db push

npx prisma db push

8. Add

out: "./drizzle"

out: "./drizzle"

to drizzle.config,ts file 9. Run

npx drizzle-kit introspect:pg

npx drizzle-kit introspect:pg

Any help greatly appreciated

GitHub

GitHub - codu-code/codu: Codú's open-source codebase. A space for c...

Codú's open-source codebase. A space for coders. Visit our community! - GitHub - codu-code/codu: Codú's open-source codebase. A space for coders. Visit our community!

GitHub

GitHub - codu-code/codu: Codú's open-source codebase. A space for c...

Codú's open-source codebase. A space for coders. Visit our community! - GitHub - codu-code/codu: Codú's open-source codebase. A space for coders. Visit our community!

1 Reply

JohnAllenOP•9mo ago

Also if theres anyway I can debug this myself please let me know how I can expose the introspect logs Ok I actually found the issue. We had tablesFilter: ["drizzle_*"] for some reason. This was filtering all the tables. TLDR remove the tableFilter to find all tables

Gaming

Programming

introspect not finding tables for pg database