[v7.0.3]join tables between databases

[Peter Paskoff]

at first - can´t change the server version, so i have to live with the
limitations of the version.

since there is no ability to create queries between different
databases in this version - how can i cover my problem described
below?

i guess, one part of the solution is to use pgdump, but how to
continue?

i have a set of subproject_id´s as result of a query in database_A
which contain in one of its tables all projects with their linked
subprojects.

in database_B are tables with names that are correspond with the
subproject_id´s (e.g. subproject_id is 500 -> tablename is p500).

the tables in database_B are contain the project-times of our
collegues (project_id, date, user_id, activity, time spent).

also in database A are tables for the user_id/name- and
project_id/theme-conversion.

so how can i create a table that contains e.g. project 1 (subproject 5
to 10) from database_A with all corresponding informations from
database_B?

for exporting the result i think is CSV the best solution (further
processing in excel).

please help me!

thanks
peter