pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIs it possible to connect to another database
3+ messages / 3 participants
[nested] [flat]
* Is it possible to connect to another database
@ 2003-07-17 14:03 BenLaKnet <benlaknet@icqmail.com>
2003-07-17 14:05 ` Re: Is it possible to connect to another database Adam Witney <awitney@sghms.ac.uk>
2003-07-17 14:06 ` Re: Is it possible to connect to another database Viorel Dragomir <bc@vio.ro>
0 siblings, 2 replies; 3+ messages in thread
From: BenLaKnet @ 2003-07-17 14:03 UTC (permalink / raw)
To: pgsql-sql
Hi,
I try to find how is it possible to connect 2 databases, with a symbolic
link.
I have to use tables in another database to test user or other information.
Ben
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is it possible to connect to another database
2003-07-17 14:03 Is it possible to connect to another database BenLaKnet <benlaknet@icqmail.com>
@ 2003-07-17 14:05 ` Adam Witney <awitney@sghms.ac.uk>
1 sibling, 0 replies; 3+ messages in thread
From: Adam Witney @ 2003-07-17 14:05 UTC (permalink / raw)
To: BenLaKnet <benlaknet@icqmail.com>; pgsql-sql
Take a look at dblink in the contrib directory... This may do what you need
adam
> Hi,
>
> I try to find how is it possible to connect 2 databases, with a symbolic
> link.
>
> I have to use tables in another database to test user or other information.
>
>
> Ben
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is it possible to connect to another database
2003-07-17 14:03 Is it possible to connect to another database BenLaKnet <benlaknet@icqmail.com>
@ 2003-07-17 14:06 ` Viorel Dragomir <bc@vio.ro>
1 sibling, 0 replies; 3+ messages in thread
From: Viorel Dragomir @ 2003-07-17 14:06 UTC (permalink / raw)
To: BenLaKnet <benlaknet@icqmail.com>; pgsql-sql
$db_conn1 = pg_connect("dbname=db1");
$db_conn2 = pg_connect("dbname=db2");
.....
You can't join two tables from different databases(, as far as i know :).
----- Original Message -----
From: "BenLaKnet" <benlaknet@icqmail.com>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, July 17, 2003 5:03 PM
Subject: [SQL] Is it possible to connect to another database
> Hi,
>
> I try to find how is it possible to connect 2 databases, with a symbolic
> link.
>
> I have to use tables in another database to test user or other
information.
>
>
> Ben
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-17 14:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-17 14:03 Is it possible to connect to another database BenLaKnet <benlaknet@icqmail.com>
2003-07-17 14:05 ` Adam Witney <awitney@sghms.ac.uk>
2003-07-17 14:06 ` Viorel Dragomir <bc@vio.ro>
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