© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
6 replies
freak4pc

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"
ebe222f993019c4b354b4484eed2fdf1efddd9abe2ff0df097eadc1f842be155.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Joining auth.user on foreign key id?
SupabaseSSupabase / help-and-questions
4y ago
Supabase Auth instead of Auth0?
SupabaseSSupabase / help-and-questions
7mo ago
How to allow optional user_id foreign key for data?
SupabaseSSupabase / help-and-questions
4y ago
supabase calling supabase.auth.user().id crashes server error 500
SupabaseSSupabase / help-and-questions
4y ago