470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

[v7.0.3]join tables between databases

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
Jul 19 '05 #1
0 1680

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by steve | last post: by
40 posts views Thread by rdemyan via AccessMonster.com | last post: by
5 posts views Thread by john7 | last post: by
2 posts views Thread by =?Utf-8?B?VGVycnk=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.