Postgres Pro
Downloads
Home   >   mailing lists

Re: quoted variables in pgsql - Mailing list pgsql-sql

From Tom Lane
Subject Re: quoted variables in pgsql
Date
Msg-id 9089.1167967568@sss.pgh.pa.us
Whole thread Raw
In response to quoted variables in pgsql  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
Tree view 
chester c young <chestercyoung@yahoo.com> writes:
> cannot get those quotes around the value.

Use backslashes.

regression=# \set var '\'value\''
regression=# \echo :var
'value'
        regards, tom lane

pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: quoted variables in pgsql
Next
From: "Travis Whitton"
Date:
Subject: Re: How to reduce a database