You shouldn't need to query an index table directly as Phoenix will use an index automatically based on a determination by the optimizer that it's more efficient to do so. If for diagnostic purposes you need to query the index table directly (or any table that uses special characters in the column name), you can surround the column name by double quotes.

Thanks,
James

On Mon, Jul 3, 2017 at 10:44 PM, 曾柏棠 <zengbaitang@qq.com> wrote:
hi all
    the column name in index table contains some special char, for example colon, this will cause some error . 
    so my question is how to query index table correctly?

Thanks !