Variable interpolation in vertica client
A basic question regarding variable interpolation in the vsql client - how can it be done within strings?
> \set schemaname myschema > select count(*) from :schemaname.foo; -- works > select analyze_statistics(:schemaname'.foo', 10); -- throws error
The intent for the second command is to interpolate schemaname into the string being passed in to analyze_statistics. I've tried various forms of syntax, but without success. Thanks.