postgresql: create a file.sql that execute more files.sql

Question

I want create a file.sql that execute with:

> psql -f file.sql

in this file I want create some schemas and tables end execute other sql files:

file.sql:

create schema a ...
create schema b...
create table a.t1
create table b.t2...

execute /path/file2.sql;
execute /path/file3.sql;

Is possible?

Answer 1

Yes, it is.

\i /path/file2.sql;
\i /path/file3.sql