I just wrote '#' to show it is command line, but actually I ran the psql as
user postgres, just like the SQL server process is running. So if it was
deceptive, I am sorry.
-eredeti Üzenet-
Feladó:Francisco Olarte
Elküldött:Hétfő 2016.06.27 11:23
Tárgy:Re: [GENERAL] dblink authent
I've got some additional info about the problem.
After several times trying to connect to the remote database, I tried to
connect to the local database with dblink. I edit the .pgpass file like this:
127.0.0.1:5432:*:postgres:password
192.168.1.40:5432:*:myusername:mypassword
Then I tried to
Yes, I missed that. Thank you, it solved the problem. And I had to edit the
/etc/hosts file too, to make it sure to find the right host.
Eredeti üzenet
Feladó: Adrian Klaver
Dátum:2016.06.27. 15:28 (GMT+01:00)
Címzett: Attila Kiss
Másolatot kap: pgsql-general
end results
I get a single column result of type record which is a comma separated record
containing the three columns.
This seems to be some problem with local function.
Can you please help with this too.?
Regards,
Piyush
From: Attila Kiss [mailto:kiss.att...
