I am able to connect to Greenplum from Qlikview using PostgreSQL (psqlodbc.msi downloaded from http://www.postgresql.org/ftp/odbc/versions/msi/). However the database I connect to has multiple schemas and I am unable to select the schema I want in the connection process. It seems to me that it defults to one schema - not the one I wnat though.
Can anyone help - please?
Thanks,
Ying