Automatically give grants to particular users PostgreSQL
There is alter default privileges, but this does not accept a wild card for the users it will apply to (i.e. the creating roles).  You have to list every possible creating user, which is quite a drag.