# Using postgres user to login the db directly in console.
select * from auth.users;

ERROR: permission denied for table users It works for previous supabase DB, using postgres user. Looks like postgres doesn't have the permission to view auth.users. Is this new ? With that being said, the solution mentioned by you no longer work for new SUPABASE db (permission denied to view auth.users). Bummer.

Hey @User, did you get an answer for this? I'm looking for this use-case implementations as well.

Anyone knows how to add references for

auth.users

via the web ui when adding columns?

You should avoid doing this because the

auth.users

table isn't accessible from the client library, preferred method is to create a

public.users

table that has the same

uuid

as that used in the

auth.users

table to handle references

@User check this guide on how to do this https://supabase.io/docs/guides/auth/managing-user-data

ahh, i see. okay! i understand now. thanks alot

Hi guys! soo I am fairly new in supabase and I am trying to get a query for my vue app similar to this.. Yes, i have read the docs and tried to apply their instructions. But I can't really get the hang of it. Can anyone help?

Supabase uses PostgREST as the API, so you could check how to query relationships with that directly here https://postgrest.org/en/v4.1/api.html#resource-embedding

you can also do it like this

supabase.from('comments').select('id, created_at, post_id(title)')

assuming

post(title), comment(post_id)

kind of structure.

@User probably best to move the conversation in a thread so its easier for others to contribute to it

Is there any good tutorials on how the storage policies works?

How do people track table schemas? (e.g., that table t1 contains columns c1 and c2)

I turned on a policy for RLS, and now when I try to directly update the schema of a table via postico (logged in as the Postgres user) I'm unable to do so with the error message:

"PostgreSQL said: must be owner of table X"

- anyone seen this before?

If it's helpful feedback, I found the managing-user-data stuff to be a bit confusing over all - e.g. what should I do in the Supabase UI, vs via raw SQL queries. I'd also suggest couching the example with a few more tables to show how a larger system might be set up and come together where users are posting their own data & taking actions in them

Any idea what might have happened that is preventing me from editing the schema of the table via that

postgres

user?

I ended up adding it from the Supabase SQL query UI but I'm unclear still on why I wasn't able to do it via the Postico interface

I think the example projects show a bit of this already

This might be due to what @User was saying yesterday about a superuser no longer being used in Postgres 13

As a feedback item, I do find it a bit strange that you can't see the User ID references in the "Tables" UI, i.e. I'm checking via a direct connection that everything is running as expected

This is a bug which I have reported a few days ago https://github.com/supabase/supabase/issues/2633 a discussion on it can be seen on the Discussion board https://github.com/supabase/supabase/discussions/2622

anyone know why the difference elements on my site aren't syncing up with transition all 0.3s?

Hey all - what Type do you use for monetary values? I know using Float isn't typically recommended due to rounding issues, however Supabase doesn't have Decimal, or Money, etc. (typically used for Monetary values)...

Use int, and store the full value as the smallest denomination (e.g. $31.10 === 3110 cents). Perform formatting on the front-end - JS in particular would change

31.10

to be

31.1

, whereas doing

3110.toFixed(2)

would display it as

31.10

. You also have the

intl

support in many environments for formatting currency correctly.

Ah great idea @User , thank you 🙂

PostgreSQL does have a money type, but you’d have to create your table with SQL and not through the dashboard. https://www.postgresql.org/docs/9.1/datatype-money.html

Very good to know.

Hello. This is the first time I am using some cloud storage service. I'm having problem streaming the video files that have been uploaded.

I realise that it's a newly added feature and the docs do not help much right now

In order to stream the video, do I need to send a download request using the supabase-js library?

nvm i think i got it. I'll try using the signedUrl for the video and put that into html5 video src.