DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?

[saeki_takuya_mk]

Hi,

I had connected to PostgreSQL view using DB Connect.
After I add new fields to the view, I tried to select the new fields on 'Database Query' tab but failed with follow error : "column does not exist".

It seems DB Connect doesn't recognize to be changed schema.
But I can get complete schema data on 'Database Info'.

How can I use the new field on query?

I did restart Splunk on browser , but couldn't resolve it.
Configuration > Server Control > restart Splunk

Thanks

[saeki_takuya_mk · Accepted solution]

The problem has been resolved.

Solution is that specify view-name with double quote ' " '.

like this..

| dbquery "myDB" "SELECT * FROM \"the_view_name\"" limit=1000