Vivekananda,
1. These question is not one for pgadmin. They are best
addressed in postgres general forum.
2. Postgres does not facilitate inter-database connectivity.
However, you can use the dblink
utility that you will find in
postgresql-8.0.3/contrib/dblink.
3. Please send any fu
On 7/4/06, Sim Zacks <[EMAIL PROTECTED]> wrote:
I can think of numerous examples where someone might want to run a
query against databases on different databases or servers.
I don't think it has anything to do with design.
Couldn't agree more.
t.n.a.
---(end of broadca
As an aside, Vivekananda, your questions (all of the recent ones) belong on the
pgsql maillist
and not on the pgadmin maillist and you shouldn't be emailing the
pgadmin owner as well.
And he probably shouldn't be posting html either!
;-)
Antoine
--
This is where I should put some witty comment
I can think of numerous examples where someone might want to run a
query against databases on different databases or servers.
I don't think it has anything to do with design.
You might think it is better to move the data together before running
the query, but that takes a lot more time and effort
You should never design a database structure that
requires you to access a completely different database. The best way to
keep data separate, yet give your users access to the uniqueness of a separate
structure, is to create different schemas.
You may wish to spend some time re-thinking th
