Hello, I'm new to working with a database like sup...
# helpd
dope
04/15/2022, 5:59 PMHello, I'm new to working with a database like supabase and I'm wondering how can I update all (replace with a different value) rows from specific column in a table every 24 hours? (I'm possibly looking for a SQL query solution)
n
Needle
04/15/2022, 5:59 PMHello @dope!
This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``.
Pinging @User so that they see this as well!
Want to unsubscribe from this thread?
Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates.
Want to change the title?
Use the
/titleg
garyaustin
04/15/2022, 6:12 PMYou will need to use the pg_cron extension.
https://supabase.com/blog/2021/03/05/postgres-as-a-cron-server
Then you can put your sql code to update the table rows where it says put your code between....
Copy code
select
cron.schedule(
'cron-name', -- name of the cron job
'* * * * *', -- every minute
$$
-- Put your code between two dollar signs so that you can create full statements.
-- Alternatively, you can write you code in a Postgres Function and call it here.
$$
);n
Needle
04/15/2022, 6:12 PMdope (2022-04-15)
d
dope
04/15/2022, 6:49 PM Copy code
select
cron.schedule(
'update-mods',
'* * * * *',
$$
update testtable set kek = 'lppl'
$$
);dope
04/15/2022, 6:49 PMis this right? cause it doesn't seem to update the value every minute
g
garyaustin
04/15/2022, 6:54 PMYou might need to add 'where true' to that as Supabase has an extension installed to prevent people from accidentally wiping out their table with updates without a 'where' clause.
d
dope
04/15/2022, 6:58 PMit worked! thank you so much!
n
Needle
04/15/2022, 7:05 PMThread was archived by @dope. Anyone can send a message to unarchive it.