Re: passing values into .sql scripts - Mailing list pgsql-sql

From Geoffrey Knauth
Subject Re: passing values into .sql scripts
Date
Msg-id 285D609A-D8C1-4E37-8D45-89E85A155FA6@knauth.org
Whole thread Raw
In response to Re: passing values into .sql scripts  (Michael Fuhr <mike@fuhr.org>)
List 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\''



pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: passing values into .sql scripts
Next
From: Daryl Richter
Date:
Subject: Re: showing multiple REFERENCE details of id fields in single