Supabase Foreign Key to Identity ID instead of Auth User ID
I have a foreign key between owner_id and the Supabase User ID. is there any way to have that relation to the IDP (Identity) ID itself? (in my case Keycloak)
Something like
auth.identities.provider_id
auth.identities.provider_id
doesn't seem to work, getting:
ERROR: 0A000: cross-database references are not implemented: "auth.identities.provider_id"
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.