Yes, I was thinking the same but happens too when I add the parenthesis.

Now when I execute this insert give me this error: 

I read the doc you gave about inserts but I'm not getting a SQL Error that are described there, any idea of what the problem can be?

Again, thanks a lot for the help Robert!!

Now I see the table, but now I need to copy/migrate the data from HSPI_Data.patient (in cache) to PostgreSQL. 

How can I do that?

This is my recently created linked table. (i got to move the data there)