Re: Multiple database queries

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple database queries
Date: 2005-10-02 13:35:00
Message-ID: 20051002133500.GB1612@kaufbach.delug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Cosmopo <tempo(at)marquo(dot)com> schrieb:
> Does the new version 8.0.x ofter this feature? We need to create
> several databases based on our customer's specs... but we need our own
> customer, permission, history, etc database. We want to be able to
> query 2 database that would have share customer's ID and other info.

You can't.

> If not, what is the best workaround?

dblink.
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink

Regards, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Manes 2005-10-02 13:47:59 Maximum # of schemas
Previous Message William ZHANG 2005-10-02 12:51:50 Re: Multiple database queries