Well, work was started on porting scoop to Postgres, but I haven't heard anything about it for a while now. I think it's a good idea to let scoop run on your favourite database (even though I don't have a favourite)
I don't know if the database schema is documented anywhere - at least, I haven't seen it - but if you do, I'm sure a contribution to the scoop administrator's guide would be appreciated.
The story Postgres Scoop has some discussion of the kinds of things that need changing to get away from mysql.
--
Discuss the art and craft of writing