Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table 7chat(x int);
ERROR:  syntax error at or near "7"
LINE 1: create table 7chat(x int);
                     ^


create table "7chat"(x int);
select * from 7chat;
ERROR:  syntax error at or near "7"
LINE 1: select * from 7chat;
                      ^


select * from "7chat";
create table chat7(x int);
select * from chat7;