Thx for the replies
What I found after really reading the man pages of psql is the -v switch
So the following now works for me:
psql -f sql.file -v month=$month
and I have the variable :month in the sql.file
Regards
Mark Campbell
Confidentiality Notice: http://ucs.co.za/conf.html
Tom Lane wrote:
Mark Campbell <mdc@ucs.co.za> writes:
the perl script generates a variable called $month (which is the current
month), I then need that month variable passed as a command line line
parameter to psql. eg psql -f sql.file --variable "month = $month"
then do a SELECT with the variable called :month
How about something like
( echo "\set :month = $month" cat sql.file) | psql
regards, tom lane