Re: Table sizes - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Table sizes
Date
Msg-id bf186f78-8f6c-7902-908e-20d9ac2d20c2@aklaver.com
Whole thread Raw
In response to Re: Table sizes  (luis.roberto@siscobra.com.br)
List pgsql-general
On 9/30/20 6:54 AM, luis.roberto@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.klaver@aklaver.com



pgsql-general by date:

Previous
From: luis.roberto@siscobra.com.br
Date:
Subject: Re: Table sizes
Next
From: Charles Clavadetscher
Date:
Subject: Re: Table sizes