pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Troy <tjk@tksoft.com>
To: a_schnabel@t-online.de
Cc: pgsql-sql@postgresql.org
Subject: Re: Diferent databases on same query...
Date: Tue, 23 Oct 2001 08:03:05 -0700 (PDT)
Message-ID: <200110231503.IAA27083@smtp3.tksoft.com> (raw)
In-Reply-To: <no.id>

Just my two cents on the issue:

A good reason would be having several databases which
each use the same set of tables which contain some information
which takes a lot of storage, such as dictionaries or map 
information. You wouldn't want to maintain several copies
of 500 Mb tables, especially if they get updated frequently.

The workaround, for now, is to have a table just for the 
foreign keys for the different systems, and to query the
shared database separately from within your programming 
environment.


Troy


> 
> 
> "Douglas Rafael da Silva" <douglas@inducola.com.br> schrieb im Newsbeitrag
> news:3BCF859C.D42C8895@inducola.com.br...
> > Hi,
> >
> > I'd like to do a query where can be possible I access tables from
> > diferent databases on the same query.
> > On MySQL, I do:
> >
> > But Who I can to do this on Postgresql ?
> 
> You CANNOT do that with PostgreSQL.
> But why do you want to do that? IMHO it's a rather bas design to hold data
> in different places, if you need to select them in one query.
> Is there a real reason to hold the tables in different databases?
> 
> Andre
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 




view thread (9+ messages)  latest in thread

Message-ID: <200110231503.IAA27083@smtp3.tksoft.com>
Permalink:  ../200110231503.IAA27083@smtp3.tksoft.com/
Also on:    postgresql.org/message-id/200110231503.IAA27083@smtp3.tksoft.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tjk@tksoft.com, a_schnabel@t-online.de
  Subject: Re: Diferent databases on same query...
  In-Reply-To: <200110231503.IAA27083@smtp3.tksoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox