I just wondered if there is a way to change the variable sign from : to $, like
\set avar 32 select :avar ; ---> select $avar ; so I can copy and paste my perl code directly to psql when debugging, assuming I do a proper \set. TIA. Ben Kim Developer College of Education Texas A&M University ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq