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

_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to