Including SQL files in extension scripts

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Including SQL files in extension scripts
Date: 2018-04-10 15:32:00
Message-ID: CAMa1XUjV0cWqpssp=Jk=qvDEfNL6RMVBu-1WqqGUkwNR7aOB+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In writing extension update scripts, I find it to be really difficult to
grok diffs for example in changed view or function definitions when a new
extension script has to include the whole definition in a new file. I want
to rather use separate files for these objects, then use something like
psql's \i to include the definitions so that version control (and
management of these files) becomes easier, but this does not appear to be
supported. Does anyone have any recommendations here?

Currently, I often simply opt to create a script that builds out the
extension SQL files from separated sql files so that I can more easily
maintain them. But I was hoping there is a better way. Any ideas would be
much appreciated.

Thanks,
Jeremy

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-04-10 15:34:17 Re: Boolean partitions syntax
Previous Message Robert Haas 2018-04-10 15:28:07 Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS