PostgreSQL Extension Code Organization
I was going to title this “Why is my extension failing to install in 9.3?”, but I figured a more general post about how I’ve been organizing my extension code would be more helpful. But I will also be answering that question along the way since my organization method provided a solution for me.
For extension installation, the code that installs objects within the database must be in a file in the format extension–version.