periodically we restore a dump of the production postgres db into both our development and stating machines. we have a SQL script that we run after this restore. It changes some basic settings like changing the site name, turning off SSL, deactivating users, etc. I modified it from a script Brian gave me.

We have a new person who is interested in doing development for one of our labs. Is there a mechanism using SQL such that we can make his user a site admin? the issue is that he's not a site admin on our production server, but he would want to be one on his development machine. I'd like to allow him to do the same postgres restore I'm using. using a SQL script to make that change would be a very convenient way to do it if possible.

thanks.