fio

pig build pkg pg_fio;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_fio;		# install via package name, for the active PG version
pig install fio;		# install by extension name, for the current active PG version

pig install fio -v 18;   # install for PG 18
pig install fio -v 17;   # install for PG 17
pig install fio -v 16;   # install for PG 16
pig install fio -v 15;   # install for PG 15
pig install fio -v 14;   # install for PG 14

CREATE EXTENSION fio;

-- Read file contents (returns bytea)
SELECT fio_readfile('/etc/hostname');

-- Write content to file
SELECT fio_writefile('/tmp/output.txt', 'Hello World'::bytea);

-- Write with auto-create directory and overwrite
SELECT fio_writefile('/tmp/newdir/output.txt', 'data'::bytea, true, true);

-- Remove a file
SELECT fio_removefile('/tmp/output.txt');

-- Rename / move a file
SELECT fio_renamefile('/tmp/old.txt', '/tmp/new.txt');

-- List directory contents
SELECT fio_readdir('/usr/', '*');

-- List with pattern filter
SELECT fio_readdir('/var/log/', '*.log');

-- Create a directory with permissions
SELECT fio_mkdir('/tmp/mydir', '0755');

-- Create nested directories recursively
SELECT fio_mkdir('/tmp/a/b/c', '0755', true);

-- Change file/directory permissions
SELECT fio_chmod('/tmp/mydir', '0700');