Gauthier, Dave wrote:
>
> 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.
You may want to use the --set or --variable options of psql and then
reference the variable name in thesqlscript.
So the psql becomes:
psql --set 'var=foo' -c '\i thesqlscript'
and then in thesqlscript:
update table set column = :var;
HTH
Bosco.
