\set a multılıne varıable

From: samı <sami(dot)jan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: \set a multılıne varıable
Date: 2007-03-05 14:55:08
Message-ID: 1173106506.344036.256280@64g2000cwx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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ı

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aidan Van Dyk 2007-03-05 15:18:20 Re: PostgreSQL 8.2.3 VACUUM Timings/Performance
Previous Message Richard Broersma Jr 2007-03-05 14:52:18 Re: real multi-master replication?