Is following observation regarding "ecpg" correct ?
It is not possible to give different port number from embedded SQLs.
Following gives error on ecpg preprocessor :
exec sql connect to tcp:postgresql://localhost:1234/:dName ;
Where dName is a host variable for database name and 1234 is a port number.
The pre-processor cannot parse statement as the dName is a host variable.
Regards
S. Kumar