\set a multılıne varıable - Mailing list pgsql-general

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ı