Null values after load from Postgres DB

[antonaks]

Hello colleagues! 

I'm asking for help. I load data from Postgres DB to Qlik Sense, from 1 table (use common Postgres connector). All rows are fetched well, but my result is not matching with original table, because some columns have empty values. 

Original table has 478 000 rows and 47 columns. I don't use any filters or other manipulations, only load data. 

Why can that happens? 

Example:

[antonaks · Accepted solution]

I fixed issue with ODBC Postgress connector. 

[frank_dehner]

Hi,

I am facing the same issue when I access a PostgreSQL database. Some of the fields are empty (null), some not. It differs when I am using select * from table; or when I am calling select a,b,c from table;. For first query I always get nulls, for last query I get nulls only for some fields.

What's wrong? What was the connector issue problem?