Hey all, is it possible to copy rows into Supabase/Postgres from a .CSV without using the psql shell? (like what's mentioned in Bulk Uploading: https://supabase.com/docs/guides/database/tables#bulk-data-loading) I'm trying to copy rows from a .CSV into a table with a client query and Supabase says I need superuser permissions, but I'm not sure how to assign them to myself.

Hello @adriantoddross! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Can you explain what you mean by client query?

adriantoddross (2022-05-09)

Sorry, I was mixing up my thoughts. I manually connected to supabase’ postgres database with the node-pg package. Since we aren’t self hosted, I think the only way we can upload from CSV is when making a new table. We ended up reading the CSV line by line and inserting new rows that way. Thx for the reply!

Thread was archived by @adriantoddross. Anyone can send a message to unarchive it.