Re: dblink password required - Mailing list pgsql-general

From Oliver Kohll - Mailing Lists
Subject Re: dblink password required
Date
Msg-id 24F579A3-CC5D-4BE3-9860-09C1AAE4AFB1@agilebase.co.uk
Whole thread Raw
In response to Re: dblink password required  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
>>
>>> select * from dblink(‘dbname=database2 username=db_link password=mypassword','select username, email from appuser')
ast1(username text, email text);: 
>
> I think the problem is the above-          ^^^^^^^^^^^^^^^
>
> username=db_link should be user=db_link
>
> The accepted keywords are here:
> http://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNSTRING

Yes that’s it, thanks.

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Non-capturing expressions
Next
From: hari.fuchs@gmail.com
Date:
Subject: Re: Finding date intersections