Postfix Admin: Create a new <foo>@example.com alias to your e-mail address by direct postgres insert over SSH.

postfixadmin_addalias.sh

#!/bin/bash

DOMAIN=example.com
TARGET=mail@$DOMAIN

SSH_HOST=example.com
SSH_USER=$USER

DBNAME=postfixadmin

if [ $# -lt 1 ]; then
	echo "Usage: $0 <alias>";
	exit 1
fi

FORBIDDEN="\'\"\\\;\:\#\[\]\{\}\(\)\|\&\^\$\@\!\?\,\ \*\<\>" # '"\;:#[]{}()|&^$@!?, *<>

if grep -qP "[$FORBIDDEN]" <<<$1; then
	echo "Alias may not contain any of $FORBIDDEN (of course unescaped)"
	exit 2
fi

ALIAS=$1@$DOMAIN

CMD="\"INSERT INTO alias VALUES ('$ALIAS', '$TARGET', '$DOMAIN');\""
set -x
ssh -t $SSH_USER@$SSH_HOST sudo -u postgres psql $DBNAME -c "$CMD"