| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | luis(dot)roberto(at)siscobra(dot)com(dot)br, Charles Clavadetscher <clavadetscher(at)swisspug(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Table sizes |
| Date: | 2020-09-30 13:59:03 |
| Message-ID: | bf186f78-8f6c-7902-908e-20d9ac2d20c2@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/30/20 6:54 AM, luis(dot)roberto(at)siscobra(dot)com(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Clavadetscher | 2020-09-30 14:02:21 | Re: Table sizes |
| Previous Message | luis.roberto | 2020-09-30 13:54:32 | Re: Table sizes |