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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
