According to this documentation
http://www.postgresql.org/docs/8.1/static/ecpg-connect.html
it should work to connect in ECPG like this:
EXEC SQL CONNECT TO tcp:postgresql://bell.credativ.de:5432/pei AS myconn USER pei IDENTIFIED BY 'geheim';
(Or perhaps with single quotes, but that doesn't make a difference.)
However, in the server logs I just see this:
FATAL: database "'tcp:postgresql://bell.credativ.de:5432/pei'" does not exist
So apparently this URL parsing needs work.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
