Search Postgresql Archives

Re: accessing multiple databases using dblink

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/13/07, f.zamboni@mastertraining <f.zamboni@xxxxxxxxxxxxxxxxx> wrote:
> Good morning to everybody,
> I've to resolve this situation: I've a collection of many different databases, all identical, and the name of those databases is stored inside a table in another "central
> management" database.
> In an ideal world, I'd like with a single query to be able to recover the name of each database from the table that does contains them, and use it to do a query on each table on
> each databse joining the results.
> At the moment I'm doing it by external code, but performaces are awfull...
> At first I tough something similar to
> select * from tab_databases,dblink('dbname=' || tab_databases.name,'select count(id) from tab_data')
> could work, but it seems its not allowed to reference rows from another table inside the from level.
>
> Putting dblink outside that level allow me to use the dynamic dbname, but in that case I would need a row resource, while dblink give back a table resource...
>
> Is it possible to resolve this inside the databse?
> Thanks a lot...

This seems to be appropriate task for pl/proxy:

https://developer.skype.com/SkypeGarage/DbProjects/PlProxy

-- 
marko

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux