lowering priority automatically at connection

Hi,

I find this very helpful:

  Lowering the priority of a PostgreSQL query
  http://weblog.bignerdranch.com/?p=11

Now I was wondering whether one could have a
  SELECT pg_setpriority(10);
executed automatically each time a certain user
connects (not necessarily using psql)?

Any ideas if and how this might be possible?

Regards :)
Chris.