apostrophes and psql variables

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql-general-postgresql(dot)org(at)postgresql(dot)org
Subject: apostrophes and psql variables
Date: 2006-08-17 13:05:00
Message-ID: 44E4697C.000002.12223@tide.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-08-17 13:15:27 Re: apostrophes and psql variables
Previous Message Jorge Godoy 2006-08-17 12:45:51 Re: Best approach for a "gap-less" sequence