Bobbie Soedirgo

> can i do this without a toml file & linking? Just an update: you can now generate types without init/linking/etc. - all you need to do is to login...

I have an idea on how this might be done, but it's not very well tested - better to try it first on a dev/testing project. I'll draft up the...

@Dizotoff that's roughly it, yeah. Sorry I'm a bit behind here - might get back to this in a few weeks.

I believe we need to add a [pgbouncer](https://www.pgbouncer.org) container for this (it's unrelated to Realtime)

The CLI doesn't manage schemas like `auth`, `storage`, etc. since it uses the `postgres` role on the remote db. The CLI's `postgres` user is superuser (thus allows creating the policy...

I agree - the CLI use case is sort of an afterthought, so the permissions model used for Supabase-managed stuff has unintended implications that is only now discovered. In general...

> But I'm not really sure what the consequences of doing that are. We will be taking out superuser role access in the future, so it's better not to lean...

This is now supported.

Thanks for the report! This should be resolved in the latest version. Can you upgrade and try again?

I think instead of manually traversing the dirs, we can instead use one file as an entrypoint and use the [`\i`/`\include` directive](https://github.com/theory/pgtap/blob/ff4a30b59d602ab7a3ea48ce91402fa9bc83abdf/test/setup.sql#L1) to include other files. Or use the [`--recurse`...