On Friday 06 June 2008 2:32 am, Hermann Muster wrote: > 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'); From the documentation: http://www.postgresql.org/docs/current/static/dblink.html Don't do the above. > > > > select * from dblink('1512','select "Vorname", "Name" from > > "PERSONEN"') > > AS (Vorname text, Name text); Here do: select * from dblink('dbname=Test','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 -- Adrian Klaver aklaver@xxxxxxxxxxx
