Hello!
Is there any way to have psql variable in apostrophes?
The idea is to do something like this
\set var 'some value'
insert into aaa values(:var)
after substisution it should as simple as
insert into aaa values('some value')
I've tried all reasonable quotings
I was able to make up but no
On Thu, Aug 17, 2006 at 05:05:00PM +0400, Ilja Golshtein wrote:
> Is there any way to have psql variable in apostrophes?
>
> The idea is to do something like this
>
> \set var 'some value'
> insert into aaa values(:var)
test=> \set var '\'some value\''
test=> insert into aaa values (:var);
INSER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You must have missed one, because:
root=# \set tv1 '\'testval\''
root=# insert into test values(:tv1);
INSERT 0 1
root=#
Ilja Golshtein wrote:
> Hello!
>
> Is there any way to have psql variable in apostrophes?
>
> The idea is to do something like t