I have a SQL only postgres extension I want to make public and share on GitHub, but I want to make sure the installation process is clear to users.

I've just been copying them to the correct directory, but is there a best practice I should follow? Like providing a makefile and documenting that as the correct way of installing -- with an aside to point out that actually for this extension at present it's acceptable to just copy the SQL and control files

The extension in it's early state is visible here


  • Edited to include link to GitHub extension
  • Perhaps you could include a link to your tool/code and let us know what it does? There may be people here who may wish to install/try your code and they may have (good!) ideas about what you could improve?
    – Vérace
    Jun 25, 2018 at 11:25
  • Thanks @Vérace, I've put an initial commit onto GitHub with the most mature contents and edited my original question to link. I'm keen to get feedback since it's my first attempt at PSQL functions, and I feel a lot is inefficient
    – ocox
    Jun 25, 2018 at 12:32

1 Answer 1


I can immediately think of two extensions which have nothing to compile, only files to be copied. I would look to their Makefiles for inspiration.




Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.