Using imbedded SQL, how do I connect tp Postgresql on a remote host? - Mailing list pgsql-general

The documents do not explain clearly enough, and here are no examples
showing how to connect (via TCP/IP) to pg on another host.

I need to supply user, password and database/

Here are examples that do not work:
 //  exec sql connect "tcp:postgresql://192.168.1.1/cucumbers  user
cucumbereater/blackjack";
  exec sql connect :sharetrader;

Does someone have code that works?

If you wish to email me, remove the cucumber component above;-)