Pgschema
Hi all, can anyone guide me on the correct syntax for querying from a table with a table schema? Everything in public works fine with like db.query.publictable.findmany but as soon as I have a table with a custom db schema like myschema.table and I’ve added it to db I can’t query with db.query.myschema.table.findmany
1 Reply
Simply make sure the drizzle definitions have the table included. You can either use the cli to generate these from your database or define the schema using the schema options: https://orm.drizzle.team/docs/schemas
Drizzle ORM - Schemas
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.