The superuser restriction on the server copy command is to prevent remote users from being able to read/write files as the db server user. As an example of why that would be bad, imagine reading /etc/passwd or writing pg_conf
I believe that as a non-super user you can use the copy command with the STDIN or STDOUT parameters, but I don't know how you would write/read the correct file handle from within aolserver
