Kynn Jones wrote:
<< kj314159265358979 >>
I know that one can store multiple psql commands and SQL statements in
a separate "script" file, and then "source" the script file, e.g. with
the \i command.
My question is, can I define variables in such a script file? E.g. can
I do something like the following unix-shell-like script?
You can use psql variables
http://www.postgresql.org/docs/8.1/static/app-psql.html#APP-PSQL-VARIABLES
Be careful with quoting issues though.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
