Alteryx output data to Postgres issue

[hlam]

I am testing a simple flow to output data to Postgres (AWS RDS Postgres), with "Overwrite Table (Drop)".

A Text Input tool is used to create some sample data and output to Postgres. The flow runs successfully. I can also use Alteryx Input tool to read the whole table in, no problem.

However, when I try to read data back using "where" clause, it does not recognize the columns (error 42703). I tried it on pgAdmin, same error. But if I use pgAdmin to create the table and insert data, I can read it in pgAdmin no problem with "where" clause. So, it looks like there is something strange happening with Output tool. 

Is it some configuration missing with the Output tool?

Env:

psqlODBC 64 bit (v9 and v12 same error)

Windows 10

Alteryx Designer 2020.2.3.27789

[seinchyiwoo]

Does it work if you do where test2.Field2 > 3 instead? 

[hlam]

I tried:

where test2.Field2 > 3

where "test2.Field2" > 3

where analytics.test2.Field2 > 3

None of them worked in Alteryx Input tool or pgAdmin.