By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

[v7.0.3]join tables between databases

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.