Help Needed with Including External SQL Script in Extension Script
Hi PostgreSQL community,
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?
Regards
Ayush Vatsa
On Friday, July 26, 2024, Ayush Vatsa <ayushvatsa1810@gmail.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.