Re: pgstattuple does not work with uppercase table names

Thanks,

 

Could it be helpful to explain this in the user manual?

 

From: Magnus Hagander <magnus@hagander.net>
Sent: den 2 november 2018 11:55
To: Andreas Eriksson <andreas.eriksson@griffeye.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Subject: Re: pgstattuple does not work with uppercase table names

 

 

On Fri, Nov 2, 2018 at 11:51 AM Andreas Eriksson <andreas.eriksson@griffeye.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/
 Work: https://www.redpill-linpro.com/

Andreas Eriksson
Principal Software Engineer, Software Architect
Tel: +46 31 719 08 00
Mobile: +46 739 07 41 79
andreas.eriksson@griffeye.com



Griffeye Technologies AB
Första Långgatan 30, SE-413 27 Göteborg, Sweden
griffeye.com