Do I need to add userId column in SQL if I need to get a specific user's posts?

You’d need to update the userId column to be uuid type not text. The column def would be something like this:

userId uuid references auth.users not null

Thank you for the confirmation. But does it make difference in using uuid or text field?

Yeah for the foreign key relation to work work the type has to match. Since the type in the auto generated auth.users table is uuid you’d have to use that

I don't have

auth.users

table

You do it’s just not accessible by default since it’s a different schema (for security)

Cool