Add a method to send a placeholder value to the supabase database server so that it can fill it with the timestamp when the server received the request. Kinda like firestore.FieldValue.serverTimestamp() For context: - https://firebase.google.com/docs/reference/js/v8/firebase.firestore.FieldValue

Isn't this just setting the column value to

NOW()

by default when creating the table?

Otherwise If I remember correctly you can pass

NOW()

as a value with the

.insert

function

I don't think that should be possible, that would mean the value has to be evaluated on the database side right? Wouldn't that also mean I would be able to literally write SQL via the client sdk?

Test and see

I'm not really near my computer rn, so it'll have to wait I guess

PostgREST doesn't do anything special with

now()

. It's just that PostgreSQL has some special string values for timestamp/tz:

sql
select 'now'::timestamptz;

select 'yesterday'::timestamptz;

select 'tomorrow'::timestamptz;

All of those work.

Same goes for

insert

right?

Yes