On 9/30/20 6:54 AM, luis.roberto@xxxxxxxxxxxxxxx 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.klaver@xxxxxxxxxxx
