plpgsql_wrap v1.0 is a new PostgreSQL extension that obfuscates PL/pgSQL stored procedure source code using AES-256-GCM encryption, storing the encrypted blob directly in pg_proc.prosrc. It works identically to standard LANGUAGE plpgsql but makes source code unreadable without the encryption key. pg_dump output is also obfuscated yet fully restorable. A built-in unwrap function allows recovery of plain text using the key. Compatible with PostgreSQL 12 and above, it targets use cases where sensitive business logic must be protected when delivering code to third parties.

2m read timeFrom postgresql.org
Post cover image
Table of contents
PostgreSQL plpgsql wrap utilityLinks & CreditsAbout plpgsql_wrap

Sort: