ODBC PostgreSQL modify database name

[#1]

Hi,

Using internal tools in scripting window, qlikview write this code to connect to a database using ODBC and postgresql :

ODBC CONNECT32 TO PostgreSQL30 (XUserId is xxx, XPassword is xxx);

SQL SELECT *

FROM thedatabase."schema"."table";

If thedatabase is the same configured in the ODBC window everything is fine and I can load data.

Unfortunatly if I change thedatabase and set another databasename (which I'm sure exist) I get a odbc cross database references error.

I tried many solutions but no one works for me

How can I set another database name in scrit which is not one that is configured in ODBC tools ?

Thanks in advance and sorry for my poor english.

[#2]

Gotcha !

ODBC CONNECT32 TO [PostgreSQL30;DATABASE=thedatabase;] (XUserId is xxx, XPassword is xxx);

SQL SELECT *

FROM thedatabase.schema.table;