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