On 06/02/11 9:58 AM, Gauthier, Dave wrote:
>
> Hi:
>
> I'd like to pass a parameter into an inline psql call that itself
> calls an sql script, something like...
>
> psql mydb -c "\i thesqlscript foo"
>
> Where"foo" is the value I want to pass in.
>
on the psql command line,
-v name=value
or
--set name=value
then in your script, use :name if you want to use "value" as a sql
identifier and (in 9.x), you can use :'value' if you want to use
'value' as a string literal.
--
john r pierce N 37, W 123
santa cruz ca mid-left coast