Re: pgstattuple does not work with uppercase table names

On Fri, Nov 2, 2018 at 11:51 AM Andreas Eriksson <
andreas(dot)eriksson(at)griffeye(dot)com> wrote:

> Steps to reproduce:
>
> CREATE EXTENSION pgstattuple;
>
> CREATE TABLE "Test" AS SELECT * FROM generate_series(1, 10000);
>
> SELECT * FROM pgstattuple('Test');
>
>
>
> ERROR: relation "test" does not exist SQL state: 42P01
>
>
>

You need to quote the identifier:
SELECT * FROM pgstattuple('"Test"');

Note the double quotes inside the string, so
"singlequote-doublequote-Test-doublequote-singlequote".

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>