Can I login with this role? I need full control over my database

I believe you can only login with user: postgres. What do you need to do that the postgres user can’t?

I created a table using supabase ui but cannot set limit on varchar type. Then I tried to connect to db and update that column type manually but postgres complain that I'm not the owner of the table.

I also need to login as this user to modify an inbuilt net function (http_post). I assume it is restricted intentionally

If you created a table you should be able to update it. http_post is in the extensions schema I think.

@User Yeah, I see. If I create the table then I'm the owner but that's really a bad experience. Supabase table manager is convinient. I wish after creating the table it will grant the owner to

postgres

user so I can modify schema the way I want

You can change the owner at any time

@User really? did I miss something?

Oh how did you create the table? Not through the Supabase dashboard?

Yes, I did create that table via supabase dashboard

I always create my tables using a query editor in the Supabase dashboard

Ah, I not my case, I was using supabase interactive UI

I think you can elevate the postgres user to super user now. But that may not always be possible if they shut it down.

impossible, sir. Did you try that command on your supabase db? 🤔

I ran it a couple weeks ago

Hmm, so weird. That means they restrict it now

No, it's not restricted.

I created the project last night. Any chance that the restriction only applies to the newly created preoject?

Yeah just tried again with a database I created yesterday.

Ah, make sense, let me try

k, probably not a good idea to keep postgres as supseruser permanently, but at least you can do what you need.

Yeah, thanks for your patients and advices. I'll revert superuser right after done. Thanks again ❤️

My pleasure -- happy to help!