@User Yes and no, the issue is that there is a hash that comes back in the url that is suppose to be handled but I don't think its documented. I have this same issue with one of my apps, I'll try and resolve it soon and post the code (not React though, its Svelte but the router I'm using is similar to React Router)

I was trying to design my db using Beekeeper Studio (https://www.beekeeperstudio.io/), but I found out the tables in the public schema created in the dashboard are not owned by the postgres user, so I'm unable to alter those tables, if I create the table from Beekeeper, I can modify it in the Dashboard. I wonder if the tables created in the Dashboard can be owned by postgres user instead of supabaseadmin?

Question: there's not much documentation on how

getUserByCookie()

works. I'm wanting to use that method on a page inside of NextJS' getServerSideProps, however I receive the error "No cookie found!" Do I need to manually set the cookie from a verify email link somehow?

i could be majorly stupid but doens't getServerSideProps run before first render? (the point of it), in which cookies aren't available until after document is defined, after first render?

i guess it depends on how

getUserByCookie()

functions

cookies are available server side

hmm

not sure then ¯\_(ツ)_/¯

sorry

Hey... I don't have that problem... I use TablePlus for client connections... I created the tables from it. I use a SQL statement "CREATE TABLE public.table_name" try using public schema always...

I took a deeper look at how it's being done in this article (https://dev.to/dabit3/magic-link-authentication-and-route-controls-with-supabase-and-next-js-leo), which shows a cookie being set via an api route. This should solve my problems!

I can do that, and the table is created, but can't do it the other way around (table created in the dashboard and alter it using a client) it says something like current user is no the owner of the table. (I'm not at that computer at the moment so can't provide the exact message)

let me check right now...

The project was created today, I saw a discussion they where changing the postgres user's role to not be superuser.

You are right, is not working when you try to alter a table from a SQL cliente, when the table was created in dashboard...

I was trying to get the owner of the table but ran out of time 😅 , I don't mind having all the other schemas private and guarded by the existing supabase roles, but the public schema I think could benefit from SQL clients manipulation.

Your question can be a suggestion, we really need it

I'm glad it's not working for you too, haha, I thought it was only me. 😆 I'll open an issue.

Hahaha I think that's a common problem 😆

do you have the error message?

Only this... Query 1 ERROR: ERROR: must be owner of table testing... trying to alter the table from the SQL client

Issue https://github.com/supabase/supabase/issues/2618 if you want to keep track of it.

Thanks... I'll tracking it

Ah, I see. That would be great, thanks a lot. I tried everything that I could possibly think of today to no avail. Might give it a try tomorrow as well.

Just getting started with Supabase. In the Auth docs, I see that there is a UID column for users, however, when I go to my own auth table, users do not have a UID. Has this been deprecated, and if so, what is the best way to relate a user ID to another table?

Figured it out! Slight design bug - on 100% view on Chrome (using 13" MacBook Air for reference), the UID column in the auth table was out of view, and there was no way to sideways scroll to it. At 90% view, I was able to see the UID column. Love Supabase so far. Thanks for making such a great product!

how can I export my database?

I messed around on the dashboard but I couldn't find it :/

we don't have that on Supabase dashboard yet. But you can use any postgresql client tool with db connectionString under settings/database to do that

Hi all