-- 64 bit output in *.out, 32 bit output in *_3.out
-- PG14+ output in *.out/*_3.out, earlier in *_1.out/*_4.out
select oid as datoid from pg_database where datname = current_database() \gset
----------------------------------------------------------------------------------------------
create table numeric (x numeric);
insert into numeric values (0), ('12341234'), ('-567890'), ('NaN'), (null);
insert into numeric values ('-Infinity'), ('Infinity'); -- needs PG 14
\set relname numeric
\ir run_test.sql
\echo Testing :relname
Testing numeric
vacuum :"relname";
checkpoint;
select relfilenode from pg_class where relname = :'relname' \gset
select lo_import(format('base/%s/%s', :'datoid', :'relfilenode')) as oid \gset
\set output :relname '.heap'
\lo_export :oid :output
\setenv relname :relname
\! pg_filedump -D $relname $relname.heap | ./sed.sh

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: numeric.heap
* Options used: -D numeric
*******************************************************************

Block    0 ********************************************************
<Header> -----
 Block Offset: 0x00000000         Offsets: Lower      52 (0x0034)
 Block: Size 8192  Version    4            Upper    7976 (0x1f28)
 LSN:  logid ...... recoff 0x........      Special  8192 (0x2000)
 Items:    7                      Free Space: 7924
 Checksum: 0x....  Prune XID: 0x00000000  Flags: 0x0004 (ALL_VISIBLE)
 Length (including item array): 52

<Data> -----
 Item   1 -- Length:   27  Offset: 8160 (0x1fe0)  Flags: NORMAL
COPY: 0
 Item   2 -- Length:   31  Offset: 8128 (0x1fc0)  Flags: NORMAL
COPY: 12341234
 Item   3 -- Length:   31  Offset: 8096 (0x1fa0)  Flags: NORMAL
COPY: -567890
 Item   4 -- Length:   27  Offset: 8064 (0x1f80)  Flags: NORMAL
COPY: NaN
 Item   5 -- Length:   24  Offset: 8040 (0x1f68)  Flags: NORMAL
COPY: \N
 Item   6 -- Length:   27  Offset: 8008 (0x1f48)  Flags: NORMAL
COPY: -Infinity
 Item   7 -- Length:   27  Offset: 7976 (0x1f28)  Flags: NORMAL
COPY: Infinity


*** End of File Encountered. Last Block Read: 0 ***
--
----------------------------------------------------------------------------------------------
--