Re: dblink password required

From: Oliver Kohll - Mailing Lists <oliver(dot)lists(at)agilebase(dot)co(dot)uk>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: dblink password required
Date: 2014-10-25 10:50:46
Message-ID: 24F579A3-CC5D-4BE3-9860-09C1AAE4AFB1@agilebase.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>
>>> select * from dblink(‘dbname=database2 username=db_link password=mypassword','select username, email from appuser') as t1(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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hari.fuchs 2014-10-25 12:00:10 Re: Finding date intersections
Previous Message Thom Brown 2014-10-25 09:55:43 Re: Non-capturing expressions