apostrophes and psql variables - Mailing list pgsql-general

From Ilja Golshtein
Subject apostrophes and psql variables
Date
Msg-id 44E4697C.000002.12223@tide.yandex.ru
Whole thread Raw
Responses Re: apostrophes and psql variables  (Michael Fuhr <mike@fuhr.org>)
Re: apostrophes and psql variables  (Q Beukes <pgsql-general@list.za.net>)
List pgsql-general
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 any luck.

Thanks.

--
Best regards
Ilja Golshtein

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Best approach for a "gap-less" sequence
Next
From: Michael Fuhr
Date:
Subject: Re: apostrophes and psql variables