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(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
>