On 9/30/20 6:54 AM, [email protected] wrote:

------------------------------------------------------------------------

Thanks, this worked.

I wonder though, why calling pg_relation_size('users') work (I don't need to specify the schema).

Because it is in the search_path. In psql do:

show search_path;

It will show you the schemas Postgres will search for a table name without using a schema qualification.

--
Adrian Klaver
[email protected]


Reply via email to