On 12/01/2011 02:01 PM, Jay Levitt wrote:
> Is there a way to load multiple .sql files in a single transaction? It
> looks like "psql -f file1 -f file2" or "psql -f file*" was a WIP patch
> that never happened, and from what I can tell, psql ignores the -1
> parameter when reading from STDIN, so I can't cat them together either:
From the man-page, -1 works in conjunction with -f so you might try:
cat file1 file2 file3 | psql -1 -f - ...
Alternately, since -1 basically wraps your input in a BEGIN...your
statements...COMMIT you could do that yourself with a begin.sql and
commit.sql:
cat begin.sql file1.sql file2.sql ... commit.sql | psql ...
Cheers,
Steve