When I create new tables in public schema via the dashboard the owner is 'supabase admin' how do I create tables I can modify in pgadmin?

the client that uses

supabase.auth...

and

supabase.from

is the same one - it is the one initialized with url and public anon key, as you mentioned. assuming row-level security (RLS) is not implemented, this will have access to your database tables in the

public

schema (i.e. reads and writes are not restricted). to apply RLS and secure your database, you can follow this example: https://supabase.io/docs/learn/auth-deep-dive/auth-row-level-security

1 way is to alter the table ownership to another user that you use to connect to the db in pgadmin:

ALTER TABLE public.<your table> OWNER TO <your-pgadmin-user>;

another way is to just create tables as the pgadmin user after you connect there

Thanks @User - it seems obvious now 😆

Q: Dev and prod supabase instance on supabase.io? Hey guys, what would be the easiest way to manage two version of DB? How would you apply changes from dev instance to production instance? Thanks!

Is it possible to allow only certain fields to be selected for auth.uid() = id etc

nvm i can just use views

i think

is it possible to download a zip or something from supabase storage?

If u upload a zip then ya ig

yeah i ment a zip from a whole dir/bucket but guess not lol

Is there a way to export the whole users table as a CSV from Supabase?

You can use a standalone Postgres client and connect to the database and export them, something like TablePlus

Can I somehow query the auth.users table? I'd like to create a dashboard overview where editors/admins can see the latest signups (including their mail-adresses). I also have a public users table with RLS for the profile but I don't want to store the email adress in the public table.

Hello. I am wondering if it is possible to have multiple (two) sessions going at the same time on the same browser in the same tab? I am making an application where there are two players and i need them to both be logged in within the same window. im using react btw.

Thanks for the suggestion! Got it working!

@User wouldn't the players be using separate browsers/

This answered my question about selecting related data on the user table. It's not public, so it won't work. Instead, I have to relate everything to a "profiles" table that sits beside my user table. Not an answer to your question, but I thought I'd let you know you inadvertently answered my question.

But if the user changes the email address I have to sync it as well to the profile :/

You can set up a trigger, right?

Anyone know of a good article or maybe somewhere in the docs that I've over looked about rate limiting API calls from a user?

anyone need help guys, im free

No, they would be using the same browser and browser tab. I have a screen split into two sections and each player has a section. I need to have both players logged in at the same time on the same browser.

Is anyone able to provide some guidance on how to use SvelteKit with Supabase Magic link for login?

im reading the Svelekit right now, can you give me some overview for this, after that i try to help you

got it a framework.

I'm stuck on the step after an email arrives from Supabase.

With the link to login

how|?? the magic link for login is only to confirm the email then redirect you in your page