Re: [Libreoffice] PostgreSQL-SDBC in LO: build system help

Le 28/11/2011 11:47, Alexander Thurgood a écrit :

Hi all,

> However, I have no idea how you would enter the strings for a remote db
> instance, in particular, the parameter separators. Trawling around the
> net and in the postgres documentation didn't get me any further, because
> any of the strings I tried failed miserably with either a failed host
> lookup, or else a message saying that I needed to add ='' after my colon
> separators.
>
> Could you fill me in please on the string sequence required ?


OK, I seem to have figured it out from re-reading libpq documentation. 
The URL field accepts connection strings of pair KEYWORD=VALUE, so one 
can enter :

host=10.0.0.1 dbname=mydb

and then move on to the user/pwd field and connection test (I imagine 
that one could enter the usr/pwd combo in the URL field too, but I 
haven't tried that yet. I will try and write something up about this in 
the next few days unless someone beats me to it.

Alex