0 tables fetched when introspecting a postgres database

I granted all permissions to a drizzle user like this

GRANT ALL PRIVILEGES ON SCHEMA public TO prisma;

GRANT ALL PRIVILEGES ON SCHEMA public TO prisma;

But when I try to introspect with this connection string

postgresql://drizzle:[password]@db.[db_url].supabase.co:5432/postgres?searchpath=public

postgresql://drizzle:[password]@db.[db_url].supabase.co:5432/postgres?searchpath=public

I get this

[✓] 0  tables fetched
[✓] 0  columns fetched
[✓] 12 enums fetched
[✓] 0  indexes fetched
[✓] 0  foreign keys fetched

[✓] 0  tables fetched
[✓] 0  columns fetched
[✓] 12 enums fetched
[✓] 0  indexes fetched
[✓] 0  foreign keys fetched

It only fetches enums but no tables, I know there are tables and the user should have access to it drizzle-kit v0.19.12

1 Reply

hachoterOP•2y ago

the enums are the correct enums that I added so that part makes sense, but it doesn't pull any tables, all i am trying to do is pull a list of tables so I can use drizzle for more complex queries, I don't need any migrations Bump

Gaming

Programming

0 tables fetched when introspecting a postgres database