| From: | "Command Prompt, Inc(dot)" <pgsql-general(at)commandprompt(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Jo <rainbow(at)linuxfocus(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Referring a table in another database |
| Date: | 2001-11-06 00:18:06 |
| Message-ID: | Pine.LNX.4.30.0111051617210.9889-100000@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
That is correct. Currently within PostgreSQL tables are specific to
their database and can not cross-query. You will have to create all tables
within the database.
J
On Mon, 5 Nov 2001, Stephan Szabo wrote:
> On Fri, 2 Nov 2001, Jo wrote:
>
> > Hi,
> >
> > Is it possible to make a reference to a table in another database in
> > PostgreSQL? I know I can do that in Access. If it's not possible I have to
> > make all of my tables in 1 database.
>
> Not currently.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
--
--
by way of pgsql-general(at)commandprompt(dot)com
http://www.postgresql.info/
http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Command Prompt, Inc. | 2001-11-06 00:20:59 | Re: functions, shell script |
| Previous Message | Command Prompt, Inc. | 2001-11-06 00:16:46 | Re: Stored procedures |