2 replies

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

drizzle-kit v0.19.12

2 replies

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

drizzle-kit v0.19.12