COPY Command and a non superuser user?

Warren wrote:

How do I get a non superuser user to be able to run the COPY command?

You can copy to / from the stdin.

non-superusers cannot run copy to / from a file, since the copy to /
from a file does so with the access authority of the postgres user and
could be used to do "bad things" TM