Re: Perl and psql variables

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