Supabase Node adding 000 to UID

Ah sorry @Zac_Magee, I had only very little time yesterday for the forum so only posted a brief response.

But my idea was to simply use the Postgres node (since Supabase is built on top of PostgreSQL) as described here:

Then for your int8 column with values such as 7217872433909435123 run a query like SELECT id::text FROM table_with_very_long_ids;. The syntax ::text is a shorthand for the PostgreSQL CAST command.

The Postgres node will return the correct value as a string (even if your data type is numeric):

The Supabase node will not as it would use a JavaScript Number datatype:

1 Like