Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group