Where in the dashboard?

I'm not sure if you can import a .csv file to an existing table but you always have the option to import .csv file when creating a new table in the Dashboard.

Okay

Maybe the mods can help you with this.

And do you know how I can manually add data into a table that has a serial id?

If you're not keen to recreate the table, one option is PgAdmin which will let you import CSV If you need something more automated/scriptable, there are node libs like

pg-copy-streams

which can help with it

If I manually insert a new row I get a duplication error for some reason instead of the table creating an Id 1 number higher

That might be caused by the data type of "id" on the table that you have created.

it's of type serial

If you don't want the id to be +1 higher than the previous one (auto-generated ids) then you can visit: https://app.supabase.io/project/{your-project-id}/editor/table and then click on

id

attribute

If you set a default of

nextval('table_name_id_seq')

(you'd replace

table_name

with the name of your table I believe), it should work. You're going to be limited to 2147483647 rows with serial though

UUID might be more preferrable in the long run.

I agree. Any place where I'm using in need of an ID, I'd rather have something that I have to copy-paste than hoping I've got the right number (e.g. if I'm deleting a row). It's also a lot more difficult to guess a UUID, so while it won't fix any glaring security issues, it can help reduce people randomly guessing an ID

Sorry, helping about what?

Original question: https://discord.com/channels/839993398554656828/839993398554656831/871032440334979112

I mean, how a mod could help with that? xD

Can I autogenerate uuid within supabase or needs to come from my app?

They can be autogenerated if you set the field to do that