Re: Table sizes

2020-09-30 Thread Charles Clavadetscher
Hello On 2020-09-30 15:54, luis.robe...@siscobra.com.br wrote: De: "Charles Clavadetscher" Para: "luis.roberto" Cc: "pgsql-general" Enviadas: Quarta-feira, 30 de setembro de 2020 10:46:39 Assunto: Re: Table sizes Hello On 2020-09-30 14:11, luis.robe...@si

Re: Table sizes

2020-09-30 Thread Adrian Klaver
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 d

Re: Table sizes

2020-09-30 Thread luis . roberto
De: "Charles Clavadetscher" Para: "luis.roberto" Cc: "pgsql-general" Enviadas: Quarta-feira, 30 de setembro de 2020 10:46:39 Assunto: Re: Table sizes Hello On 2020-09-30 14:11, luis.robe...@siscobra.com.br wrote: > Hi! > > I'm trying t

Re: Table sizes

2020-09-30 Thread Charles Clavadetscher
Hello On 2020-09-30 14:11, luis.robe...@siscobra.com.br wrote: Hi! I'm trying to use this query to get table sizes, however I'm getting a strange error: select tablename,pg_relation_size(tablename::text) from pg_tables; In PG 13: SQL Error [42P01]: ERROR: relation "sql_implementation_info"

Re: Table sizes

2020-09-30 Thread Ireneusz Pluta/wp.pl
W dniu 2020-09-30 o 14:11, luis.robe...@siscobra.com.br pisze: Hi! I'm trying to use this query to get table sizes, however I'm getting a strange error: select tablename,pg_relation_size(tablename::text)   from pg_tables; In PG 13: SQL Error [42P01]: ERROR: relation "sql_implementation_info"