Bug#659216: what to use in with the database connect url?

[Lionel Elie Mamane <lionel@mamane.lu>]

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