Trying to use PostGree SQL conector to access some info... but get always an error

[kickoff07]

Hi -

I'm trying to get data using the Postgree database conector in qlik cloud. The query run from my laptop works perfectly (it's a test query just to test). But not through qlik conector:

LIB CONNECT TO 'ABX';

LOAD [CUPS] AS [CUPS];
sql
select cups as CUPS from hourly_consumptions_pro limit 10;

Reply:

Connected

The following error occurred:

(Connector error: ERROR [XX000] [Qlik][PostgreSQL] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR: line 1:7: no viable alternative at input ';declare')

The error occurred here:

sql select cups as CUPS from hourly_consumptions_pro limit 10

Data has not been loaded. Please correct the error and try loading again.

Any thoughts on this ?

[benoithervochon]

Hello

When "The query run from my laptop works perfectly "  -> with Qlik Sense Desktop ? or other tool ?

[kickoff07]

My Postgre SQL client (outside Qlik)