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

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