Go to edit column and just change the type

When I attempt to change it in the UI I get an error

Error: Cannot read property 'accept-version' of undefined

Try with sql: ALTER TABLE table_name ALTER COLUMN column_name datatype;

thanks that works, though looks like I can't use

Text

type for an id column

identity column type must be smallint, integer, or bigint

I'm not an sql expert but i think that's because is a primary key with autoincrement or something like that

Yeah makes sense. Is there a way upsert a row based on a column other than the

id

?

I have an

address

column, and I want to update a row with a specific

address

if the row exists, insert otherwise.

Thanks, yeah I was just wondering if there was a recommended way to doing it using the supabase api client

might be able to make this work by adding a unique contraint to my field

Hi! I'm making my first Supabase app and was hoping someone could help me out logically. The app allows photographers to create a model release. Once created, the model will receive a token tied to the release. What kind of policy can I set in place for: 1. Model to be able to access model release using the token ONLY (no auth account) 2. Be able to update it by adding their signature 3. Not be able to access any other model releases by id, user, etc because the model will only have the token

IS there a way to change where the Postgre REST API is pointing for databases? I'm testing supabase on a docker container, and I've created a db with a different name other than

public

. I'd like to point to that database, but I don't know how to do that using REST APIs. Looks like they point by default to the

public

db

@User please help why are you ignoring us I'm paying customer

Hey @Mohamed Osman - this is a Community-led Discord (as we mention in the #867318180615421973 channel). We’re a small team so it’s hard to keep up with all the messages here. If you have a serious issue the best option is to email beta@supabase.io. I see above that it’s about changing the upload size - we haven’t done that for anyone yet because we are still in Beta. If you send all the details to that email we can consider it depending on your use case. Storage is an area which sees a lot of abuse, and so we have to be strict otherwise one customer can harm every other customer (as was the case with Verizon blocking a domain name). We will gradually open up the limits when we have more checks in place

@copple thanks I understand that and more than happy to follow any guidelines I've sent multiple emails to that account and have gotten no response yet Was confused little bit but Thanks again for clearing that up for me and I'm just gonna wait I guess then

I’ll check out the ticket later

need help on how to query the object storage through API, anyone can help?

I try to query the object storage API https://.supabase.co/storage/v1/bucket but getting Invalid JWT

There are some examples in the QuickStart @knight - do they help? https://supabase.io/docs/guides/with-react

those are with library, I wanna see saome sample pure API , doing some integration with Retool

Ok cool. You need to add the ANON key as a header “apikey” and the “Authorization” (bearer)

can't use services key ?

You can

apikey = and I still need to add Bearer token ?

not really working, try diff comobo between service key + anno key

That looks about right but I’m on my phone so I can’t verify what the changes need to be. @joshen you online? ☝️

I’ll be at my computer in 1 hour @knight

thanks @User really appreatiate it!

Sounds like Leo has answered this on our support emails @User . Thanks for emailing through the support channel 🙏