I'm using pgAdminIII SQL Editor to develop a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about using psql -f in the command-line and \i to include these files, but I'd rather use a GUI to execute my scripts while I develop and test locally.

Is this possible? Any references/documentation would be very helpful.

EDIT: For clarity, I'm not asking about better products to use other than pgAdmin (unless the product can do what I'm asking above), nor am I asking how to do this in psql - I already have documentation for that and I don't want to use the command line. Preference is for executing the master.sql script file in a sql editor.

I'm developing a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about using psql -f in the command-line and \i to include these files, but the preference here is to avoid the terminal and use a GUI to manage my database and execute the master.sql script.

Is this possible in any postgres admin GUI? Presumably it's not in pgAdmin.

I'm using pgAdminIII SQL Editor to develop a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about using psql -f in the command-line and \i to include these files, but I'd rather use the GUI to execute my scripts while I develop and test locally.

Is this possible? Any references/documentation would be very helpful.

EDIT: For clarity, I'm not asking about better products to use than pgAdmin, nor am I asking how to do this in psql - I already have documentation for that and I don't want to use the command line. Preference is executing master.sql script file in sql editor.

I'm using pgAdminIII SQL Editor to develop a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about using psql -f in the command-line and \i to include these files, but I'd rather use a GUI to execute my scripts while I develop and test locally.

Is this possible? Any references/documentation would be very helpful.

EDIT: For clarity, I'm not asking about better products to use other than pgAdmin (unless the product can do what I'm asking above), nor am I asking how to do this in psql - I already have documentation for that and I don't want to use the command line. Preference is for executing the master.sql script file in a sql editor.

I'm using pgAdminIII SQL Editor to develop a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about psql -f in the command-line and using \i to include these files, but I'd rather use the GUI to execute my scripts while I develop and test locally.

Is this possible? Any references/documentation would be very helpful.

EDIT: For clarity, I'm not asking about better products to use than pgAdmin, nor am I asking how to do this in psql - I already have documentation for that and I don't want to use the command line. Thanks.

I'm using pgAdminIII SQL Editor to develop a really long script. I'd like to break the script into smaller, more manageable scripts and include each sql file in a master file, then just execute the master file.

example: master.sql

contents (I don't know the syntax to use):

file1.sql
file2.sql
file3.sql

I've found several tutorials about using psql -f in the command-line and \i to include these files, but I'd rather use the GUI to execute my scripts while I develop and test locally.

Is this possible? Any references/documentation would be very helpful.

EDIT: For clarity, I'm not asking about better products to use than pgAdmin, nor am I asking how to do this in psql - I already have documentation for that and I don't want to use the command line. Preference is executing master.sql script file in sql editor.