Hi all, I’m having difficulty using variable interpolation within psql, where that variable is within a table name… Like so.. =# set YYYYMM 201310 =# select :YYYYMM; ?column? ---------- 201309 (1 row) =# alter table my_table rename to my_table_:YYYYMM_raw; ERROR: syntax error at or near ":" LINE 1: …my_table rename to my_table_:YYYYMM_ra... ^ The problem is that psql tries to interpret ‘YYYYMM_raw’ as the variable name, but my intention is to only interpret ‘YYYYMM’ followed by a literal underscore. I can’t find any other way to encapsulate the variable name in this way… Is there a trick to it? I suspect I’ll need to work around this by altering the naming convention such that the YYYYMM is at the ‘end’ of the table name. Maybe.. Thoughts? Tim |
