I want to execute several sql scripts sequentially with psql
as a single transaction to set up my database schema. What is the best way to do this? In the past I know I had a master script that I ran psql
against that included the other files however I don't remember the syntax of this script.
Postgresql – Source several files at once with psql
postgresqlpsql
Best Answer
Your script could look like this:
Or you could do something like this: