CREATE OR REPLACE FUNCTION delete_expired_sessions() RETURNS void AS $$ BEGIN DELETE FROM sessions WHERE expires < NOW(); END; $$ LANGUAGE plpgsql; CREATE EXTENSION IF NOT EXISTS pg_cron; SELECT cron.schedule('0 0 * * *', 'SELECT delete_expired_sessions();');