We've discussed putting things into the CR for both Oracle and PG, in order to hide stuff like this. There are some concerns about scalability, but there are also advantages, like hiding the differences between PG, Oracle and other RDBMS's in one place, providing the option of storing stuff in the file system rather than db, automatic searching via the site-wide search mechanism, etc.
I'm sure Dan would be more than glad to help you out with questions, he's already done this for the APM.
