fio

pig build pkg pg_fio         # build RPM / DEB packages

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

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');