On 9/30/20 6:54 AM, luis.robe...@siscobra.com.br 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
adrian.kla...@aklaver.com


Reply via email to