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 mytable
(id integer,
file bytea);
CREATE TABLE
DO
$$
DECLARE
my_binary_file bytea = '\x232120433a2f50726f6772616d2046696c';
BEGIN
INSERT INTO mytable
VALUES (1,
my_binary_file);
END;
$$
DO
SELECT *
FROM mytable;
| id | file |
|---|---|
| 1 | \x232120433a2f50726f6772616d2046696c |
SELECT 1