On Tue, Apr 24, 2012 at 03:22:40PM +0200, Jelle de Jong wrote: > I got a working psql command and what to do some smart things with > librebase, but cant figure out how to use the database url in the wizard!!
It is a "conninfo" string as defined in http://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PQCONNECTDB, which sends you back to http://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PQCONNECTDBPARAMS; it is a space-separated list of keyword=value pairs. A more user-friendly prompt is in wishlist: https://bugs.freedesktop.org/43369 (I take patches) > psql -U username -h vps6.server.nl database > password For example, the equivalent of this psql command line is: host=vps6.server.nl dbname=database Then enter username and password in the LibreOffice dialogs for that. You can also hardcode the username (and also password) if you wish so: host=vps6.server.nl dbname=database user=HERE_THE_username password=HERE_THE_password Then, uncomment the "needs password" setting in LibreOffice. If you enter username and/or password in both the conninfo string (URL) and the LibreOffice prompts, I don't remember out the top of my head which one overrides the other one. -- Lionel -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
