Thread: \set a multılıne varıable

Hı

How do you set a multılıne varıable usıng psql ?

eg I am tryıng to add a multılıne varıable: somethıng on the lınes
of :

\set ADD_REMOTE_LINK 'SELECT '
' name from '
' mytable'


and then call ıt usıng

\echo :ADD_REMOTE_LINK

Addıng a \ at the end of the lıne does not help - I am not sure what
do to - the psql documentatıon ıs not help eıther ( or maybe I may
have mıssed ıt)

Thanks

Samı

samı wrote:
> How do you set a multılıne varıable usıng psql ?

peter=# \set foo 'abc\ndef'
peter=# \echo :foo
abc
def

--
Peter Eisentraut
http://developer.postgresql.org/~petere/