Re: Perl and psql variables

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