Tom,
Thank you. That works.
My psql does not allow me to leave off the trailing `.
It is my typing that is the problem.
Paul
Tom Lane wrote:
Paul Tilles <[EMAIL PROTECTED]> writes:
What I really want to do is the following:
\set local_site `echo $FXA_LOCAL_SITE
UPDATE table
Paul Tilles <[EMAIL PROTECTED]> writes:
> What I really want to do is the following:
> \set local_site `echo $FXA_LOCAL_SITE
> UPDATE table_name SET office_id = :local_site;
> This results in the message
>column "xxx" does not exist
Yes, because you have no quotes in the
I need to use the value of an environment variable as part of an SQL
query within psql.
I can do the following withing psql:
\set local_site `echo $FXA_LOCAL_SITE
\echo local site = :local_site
The result is "local_site = xxx" which is correct.
What I really want to do is the following
