Add CREATE EXTENSION Support

PGAdmin Hackers,

I’d like to add code to pgAgent so that its schema could be installed via a CREATE EXTENSION statement. This would greatly simplify deployment for us. In private correspondence, Dave Page suggested that CMake be updated to handle it. At a glance, I think I'd have to move things around a bit, perhaps create an SQL directory, and have CMake concatenate files (or wrap them in BEGIN/COMMIT statements) to generate the old file. Does that make sense?

Also, is there access to PGXS during the build? I'm pretty familiar with how PostgreSQL extension Makefiles should work, but not the configure/CMake stuff in pgAdmin. Pointers would be appreciated.

Thanks,

David