PostgreSQL extension for unarchiving zip archives encoded in BASE64 into text

Get

git clone https://github.com/snaiffer/pg_compress && \
  cd pg_compress && \
  git submodule init && \
  git submodule update

Build & Install

make && sudo make install && sudo service postgresql restart && \
  psql test1 -U postgres -c "create schema compress; create EXTENSION compress with schema compress;"

Example

select compress.unzip_base64('UEsDBC0ACAAIAOtlmEwAAAAA//////////8BABQALQEAEAAAAAAAAAAAAAAAAAAAAAAAsynKL7ezKclMsTM0MrbRBzFsEnPzS/NK7AwNDGz0oWwbfZA6LgBQSwcI/0unGSYAAAAAAAAALgAAAAAAAABQSwECHgMtAAgACADrZZhM/0unGSYAAAAuAAAAAQAAAAAAAAABAAAAgBEAAAAALVBLBQYAAAAAAQABAC8AAABxAAAAAAA=')

Result: 123100