Re: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database).
On Mon, 21 May 2001 07:55:13 -0400 Andrew Rawnsley <[EMAIL PROTECTED]> wrote: > If I ever come up with said schema-dropping patch, and anyone else wants it, > let me know. I'd dance a happy jig ;-) I'm not sure whether it is quite the way to do it, but I'd have a better time with things if I could span databases in a single request. Are there theoretical problems with spanning databases in a single query? Is it a feature of bad database design & implementation? Thanks Ciao Zak -- Zak McGregor http://www.carfolio.com - Specifications of cars online. Over 7000! Of course my password is the same as my pet's name. My macaw's name was Q47pY!3, but I change it every 90 days. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
RE: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database).
Oracle financials has about 2000 tables in a single database :> but of course that must not be designed using structured design techniques. -- Ian Willis -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Saturday, 19 May 2001 12:45 AM To: Trygve Falch Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database). "Trygve Falch" <[EMAIL PROTECTED]> writes: > And putting 200+ tables in one single database is not an option. Why not? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html