Using imbedded SQL, how do I connect tp Postgresql on a remote host?

I tried another group without success, so....

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;-)