Re: Accessing other databases with DBLink when leaving user/password empty

Does no one have any idea about that?

Regards.



Hermann Muster wrote:
> Hi,
>
> I have the following problem when trying to access other PostgreSQL
> databases with DBLink. I followed the instructions on
>
http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html.

>
>
> My query to get access to another database on the same server looks like
> this:
>
>     select dblink_connect('1512','host=127.0.0.1 port=5432
>     dbname=Test user=postgres password=postgres');
>
>     select * from dblink('1512','select "Vorname", "Name" from
>     "PERSONEN"')
>     AS (Vorname text, Name text);
>
> The question is if it is possible to leave the 'user' and 'password'
> empty, so that these are taken from the account I'm currently using, as
> described below (taken from the above article).
>
>     [...]
>     Below is an example of querying a database on the same server
>     and cluster using DbLink. Note if no username and password is
>     specified, then DbLink connects with whatever account you are
>     currently using.
>
> It is not possible to connect to the other database when they are empty
> and it seems that DBLink can't get them from the currently used account.
> Can you please help me with that? Thank you.
>
> Regards,
> H. Muster