Hey, first of all thanks for the service. Starting...
# help
u
Hey, first of all thanks for the service. Starting to love using this on my side-project ❤️ got a question! Trying to import data (formatting json into csv then importing that into supabase), issue I am having that somehow if postal code has "0" in front e.g "00300" then value will be "300" at table. In json its on string type and when I import its type gets changed into Int automatically, and I though that caused issue with, so tried to change back to string (text) didnt helped. Any ideas?
n
Hello @uskolol! 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
/title
command! We have solved your problem? Click the button below to archive it.
o
> One example (I got 10k row of values)

https://cdn.discordapp.com/attachments/843999948717555735/961171025784107028/Screenshot_2022-04-06_at_10.49.53.png

Hi Please use this thread instead of creating a new one.
n
uskolol (2022-04-06)
f
@User u can use padleft an fill it with 0
SELECT LPAD('300', 5, '0')
u
Cheers ill try that one.
Thank you so much, had to improvise little bit but I got it working now! Thank you bro ❤️
Is this safe to use for 10k rows of values tho? Because every row will be missing leading zeroes, it can be missing up 3 zeroes from postal code
f
u can create a new column and run that update over the new column