Thread: script variables

script variables

From

Paul Cunningham

Date:

14 March 2005, 20:27:02

I use a bash script (similar to following example) to update tables.

psql -v passed_in_var=\'some_value\'  -f script_name ....

Is it possible to pass a value back from psql to the bash script?

Thanks,
Paul Cunningham

Re: script variables

From

Richard Huxton

Date:

15 March 2005, 11:23:24

Paul Cunningham wrote:
> I use a bash script (similar to following example) to update tables.
>
> psql -v passed_in_var=\'some_value\'  -f script_name ....
>
> Is it possible to pass a value back from psql to the bash script?

You can pass the textual output of psql back with backticks:
  echo `psql ...`

--
   Richard Huxton
   Archonet Ltd