Re: passing values into .sql scripts

From: Geoffrey Knauth <geoff(at)knauth(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: passing values into .sql scripts
Date: 2005-09-15 22:49:22
Message-ID: 285D609A-D8C1-4E37-8D45-89E85A155FA6@knauth.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

That did exactly what I wanted. Thank you! (I had tried \set
acct ... before, but it was your quoting that fixed my problem.)

Geoffrey
--
Geoffrey S. Knauth | http://knauth.org/gsk

On Sep 15, 2005, at 18:43, Michael Fuhr wrote:

> What's your intention here? The above sets the variable tmp to the
> value of the variable acct concatenated with 'a value', but you
> don't show acct being set anywhere. Did you mean to set acct?
> If so then try this:
>
> \set acct '\'a value\''

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daryl Richter 2005-09-16 16:16:59 Re: showing multiple REFERENCE details of id fields in single
Previous Message Michael Fuhr 2005-09-15 22:43:02 Re: passing values into .sql scripts