From: | "Brian Maguire" <bmaguire(at)vantage(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | dblink questions |
Date: | 2003-12-08 19:17:18 |
Message-ID: | 203C7FC3FF2D7A4588CE0429A87F3C9A0CD2C1@vt-pe2550-001.vantage.vantage.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Hatcher | 2003-12-08 19:45:23 | Pg_Dump of schema? |
Previous Message | Richard Huxton | 2003-12-08 18:03:33 | Re: remove |