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
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 |