Re: Help Needed with Including External SQL Script in Extension Script

On Friday, July 26, 2024, Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com> wrote:
>
> I wanted to modify the SQL script of an extension by creating multiple
> objects within it.
> My aim is to make minimal changes to the existing script. To achieve this,
> I have created an
> external script and am attempting to run it within the extension script
> using the \i command.
>
> However, when I try to create the extension, I encounter the following
> error:
> ERROR: syntax error at or near "\"
>
> Could anyone advise on how I might resolve this issue? Alternatively, is
> there another way to create SQL objects outside of the main extension
> script, such that these objects are created when the extension script is
> executed?
>

Extension scripts are executed directly by the server as SQL, not via psql,
so using psql features will not work. In short, your extension script for
a given version must be singular as the concept of “include files” is not
understood by the execution environment.

David J.