File: run_test.sql

package info (click to toggle)
postgresql-filedump 17.4-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 420 kB
  • sloc: ansic: 3,554; sql: 152; perl: 118; sh: 24; makefile: 23
file content (16 lines) | stat: -rw-r--r-- 434 bytes parent folder | download 
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

--
----------------------------------------------------------------------------------------------
--