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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
