In Supabase, is it possible to create a Row in ano...
# off-topica
Aghilan
03/26/2022, 3:38 AMIn Supabase, is it possible to create a Row in another Table anytime a User is created. This row would have the same ID column and has other pre-defined data
s
Scott P
03/26/2022, 3:43 AMYes, there are several links which explain this:
https://supabase-cheatsheet.vercel.app/docs/auth/public-profiles-table#trigger-procedure
https://github.com/supabase/supabase/discussions/5421
For future reference, general is not to be used for help requests.
a
Aghilan
03/26/2022, 3:43 AMOops sorry
Aghilan
03/26/2022, 3:43 AM@User
Aghilan
03/26/2022, 3:43 AMSorry but what in the world is a trigger?
s
Scott P
03/26/2022, 3:44 AMa
Aghilan
03/26/2022, 3:45 AMDoesnt a trigger just create a brand new table? I want to just insert a row
s
Scott P
03/26/2022, 3:46 AMNo, a trigger doesn't create a brand new table
a
Aghilan
03/26/2022, 3:47 AMLet's say I had a table with the following columns
Aghilan
03/26/2022, 3:47 AMThe table name is Finance Tracker
Aghilan
03/26/2022, 3:48 AMid: int8, UserID: uuid, Investments: text[], Expenses: text[]
Aghilan
03/26/2022, 3:49 AMCould you show me how the trigger would look like with a newUser is created in the users table
Aghilan
03/26/2022, 3:49 AMI do not know SQL and I unfortunately do not have time to learn it as I'm on a bit of a time crunch
Aghilan
03/26/2022, 3:51 AMOh damn Supabase makes it so easy'
Aghilan
03/26/2022, 3:51 AMI dont need to make SQL queries
Aghilan
03/26/2022, 3:53 AMOk nvm
Aghilan
03/26/2022, 3:53 AMI don't know
s
Scott P
03/26/2022, 3:53 AMSorry, but I've got my own things to do. There's examples in the links which should be easy to adapt to your use case.
a
Aghilan
03/26/2022, 3:53 AM@User Wait so does this trigger which listens to change call a function, and this function must use raw SQL queries?
s
Scott P
03/26/2022, 3:54 AMI'd suggest reading the link I posted above. It explains what triggers are, how to write them, things to watch out for, etc.
a
Aghilan
03/26/2022, 3:55 AMBut those use actual SQL queries?
Aghilan
03/26/2022, 3:55 AMAreant I just using Supabase?
s
Scott P
03/26/2022, 3:55 AMSupabase is based on Postgres. Postgres uses SQL. Triggers are written in SQL.
a
Aghilan
03/26/2022, 3:55 AMActually there is a vid from Supabsse online
Aghilan
03/26/2022, 3:56 AMHopefully it explaisn it because I didnt really understand the docs
Aghilan
03/26/2022, 5:02 AMOk I watched a video on setting up triggers in Supabase but it isnt working. Job for tmr