cannot figure this out # \set var 'value' # select * from some_table where some_col = :var; ERROR: column value does not exist
cannot get those quotes around the value. tried: # \set var ''value'' # \set var ''''value'''' in each case: # \echo :var value thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org