> however the COPY> command requires superuser and I really don't want to open up the DB> from a remote system with Superuser access.
COPY FROM STDIN does not need superuser privileges.