On 2011-11-09 13:27, Jeremy O'Sullivan wrote:

Hello, When connecting from Tableau, the following syntax generates and error on the command line, is this correct ? (The :w triggers the error.) Regards, Jeremy

select count(context_key) as "context_key:w" from context_dim;

It seems from looking at the code that only underscore, alphanumerics, space and parentheses are allowed as column names (including aliases). In other words, the colon is not allowed here. -- Sjoerd Mullender