When I used to use Oracle's SQL*Plus, it was possible to run SQL
scripts using the @ symbol, for example:-
@myscript.sql
and if that script referred to other embedded SQL scripts then it was
necessary to use a double @ symbol, such as:-
@@embeddedmyscript.sql
within the original script.

When I'm using the pgAdmin Query tool I would like to do something
similar.

Is that possible in pgAdmin and if so how?

gargoyle47 wrote:
I know that this is not a direct answer to your question, but
I'm encouraged anyway because you mentioned SQL*Plus.

SQL*Plus is a command line interface, and its PostgreSQL
equivalent would be psql. In psql you can use the \i
command to run scripts, and you can use \i in scripts
to call other scripts.

Usually command line interfaces are more powerful with
scripts. Would it be acceptable for you to use psql?

The direct answer to your question is "I don't know" :^)

Yours,
Laurenz Albe

On May 5, 9:43*am, "Laurenz Albe" <inv... (AT) spam (DOT) to.invalid> wrote:

Yes, I am now using psql to run scripts, although I find the interface
a little old-fashioned.
Nevertheless, it works and I will try your suggestion.

Thanks for the update.