blob: c1f67097fd5254ebb8ac6ffe7d1181f5aba13904 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
\echo Testing :relname
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
--
----------------------------------------------------------------------------------------------
--
|