What's the best way to create a connection with dblink with persisted
connections for web applications?
For example:
I want to have a view that links to a table in another pg database so I
can mask the connection and make it easier to query.
so I would do this ...
create view myremote_pg_proc as
select *
from dblink('myconnection','select proname, prosrc from pg_proc')
as t1(proname name, prosrc text);
so I can do this ...
select * from myremote_pg_proc where proname like 'bytea%';
I understand that a connection can be made by dblink_connect(text
connstr) and
dblink_connect(text connname, text connstr), but how do you suggest
making the first connection from a web application?
select dblink('myconnection','127.0.0.1 port=5432 dbname=template1
user=postgres password=mypasswd')
Do you suggestion not using the persistent connection? and do this?
create view myremote_pg_proc as
select *
from dblink('myconnection','127.0.0.1 port=5432 dbname=template1
user=postgres password=mypasswd','select proname, prosrc from pg_proc')
as t1(proname name, prosrc text);
Thanks a Bunch,
Brian