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?.
select set_config('myvar.my_binary_file', '\x232120433a2f50726f6772616d2046696c...', false)
| set_config |
|---|
| \x232120433a2f50726f6772616d2046696c... |
SELECT 1
create table test (id serial primary key, binary_file text) ;
CREATE TABLE
insert into test (binary_file) values (current_setting('myvar.my_binary_file')) ;
INSERT 0 1
select * from test
| id | binary_file |
|---|---|
| 1 | \x232120433a2f50726f6772616d2046696c... |
SELECT 1