Re: Perl and psql variables

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Mark Campbell <mdc(at)ucs(dot)co(dot)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