I have a site with discord social auth enabled, but I need to get the referenced user_id (from

auth.users

via

auth.identities

), is it possible to get the user_id? Help

Perhaps, you can create a trigger on_user_create to insert into public.profile with user_id | discord_id

Hm, I figured

Where is discord id stored?

I'm just using the

signinwithOauth()

function

you can add the trigger ON that table then right?

good question

could you check this table?

Use

raise log 'my value = %',new;

in your trigger function and look in postgres logs to see all the values. But it would be whatever column name it is in for that table new.colname. I don't use OAuth either so not sure where it goes to. Some info like the OAuth access token are not stored at all for security reasons. I don't think that table has raw_user_meta_data like auth.users.

good idea, thank you

thanks -- I'm on local for dev, but I guess I'll just have to push

Yeah, it is there, but I don't do local either. It is in the file system somewhere. But if your trigger is on that table the new.xxx means .xxx is a column name in that table.