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: (view raw, whole thread or download thread mbox)
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 S. Knauth |

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-2017 The PostgreSQL Global Development Group