pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCross-database references
8+ messages / 7 participants
[nested] [flat]
* Cross-database references
@ 2003-02-28 15:05 Sidar Lopez Cruz <sidarlopez@hotmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: Sidar Lopez Cruz @ 2003-02-28 15:05 UTC (permalink / raw)
To: pgsql-admin
When i try to do something like
templae1=# select * from mydatabase.public.mytale;
this message appear: Cross-database references are not implemented
:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Cross-database references
@ 2003-02-28 16:31 Tycho Fruru <tycho@fruru.com>
parent: Sidar Lopez Cruz <sidarlopez@hotmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Tycho Fruru @ 2003-02-28 16:31 UTC (permalink / raw)
To: Sidar Lopez Cruz <sidarlopez@hotmail.com>; +Cc: pgsql-admin
On Fri, 2003-02-28 at 16:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented
This could be because cross-database references are not implemented (yet
:-) ... for now you'll have to have local data-sources (or use some
contrib module)
Cheers,
Tycho
--
Tycho Fruru tycho@fruru.com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Cross-database references
@ 2003-02-28 20:47 Ian Barwick <barwick@gmx.net>
parent: Sidar Lopez Cruz <sidarlopez@hotmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Ian Barwick @ 2003-02-28 20:47 UTC (permalink / raw)
To: Sidar Lopez Cruz <sidarlopez@hotmail.com>; pgsql-admin
On Friday 28 February 2003 16:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented
This is normal behaviour for Postgres. This syntax is not supported,
even if the database you are referencing is the current one.
See also:
http://www.postgresql.org/docs/faqs/FAQ.html#4.24
Ian Barwick
barwick@gmx.net
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Cross-database references
@ 2003-02-28 22:17 Robert Treat <xzilla@users.sourceforge.net>
parent: Sidar Lopez Cruz <sidarlopez@hotmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Robert Treat @ 2003-02-28 22:17 UTC (permalink / raw)
To: Sidar Lopez Cruz <sidarlopez@hotmail.com>; +Cc: pgsql-admin
Check out the dblink module in contrib
On Fri, 2003-02-28 at 10:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented
>
>
> :-) Sidar Lopez Cruz
> - Cero Riesgo, S.A.
^ permalink raw reply [nested|flat] 8+ messages in thread
* cross database references...
@ 2007-05-18 13:26 Jessica Richard <rjessil@yahoo.com>
0 siblings, 2 replies; 8+ messages in thread
From: Jessica Richard @ 2007-05-18 13:26 UTC (permalink / raw)
To: pgsql-admin
Other than dblink, is there any other way to let me joint select two tables in two different databases?
Thanks,
Jessica
---------------------------------
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: cross database references...
@ 2007-05-18 14:24 Joshua D. Drake <jd@commandprompt.com>
parent: Jessica Richard <rjessil@yahoo.com>
1 sibling, 0 replies; 8+ messages in thread
From: Joshua D. Drake @ 2007-05-18 14:24 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
Jessica Richard wrote:
> Other than dblink, is there any other way to let me joint select two
> tables in two different databases?
dbi-link.
>
> Thanks,
> Jessica
>
> ------------------------------------------------------------------------
> Park yourself in front of a world of choices in alternative vehicles.
> Visit the Yahoo! Auto Green Center.
> <http://us.rd.yahoo.com/evt=48246/*http://autos.yahoo.com/green_center/;_ylc=X3oDMTE5cDF2bXZzBF9TAzk3...;
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: cross database references...
@ 2007-05-18 15:59 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Jessica Richard <rjessil@yahoo.com>
1 sibling, 1 reply; 8+ messages in thread
From: Scott Marlowe @ 2007-05-18 15:59 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
Jessica Richard wrote:
> Other than dblink, is there any other way to let me joint select two
> tables in two different databases?
Would schemas work for you? You can have multiple schemas in one
database (like oracle) so that you references tables as
schemaname.tablename etc... Works well for most places you need to do this.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: cross database references...
@ 2007-05-18 17:28 Jessica Richard <rjessil@yahoo.com>
parent: Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 0 replies; 8+ messages in thread
From: Jessica Richard @ 2007-05-18 17:28 UTC (permalink / raw)
To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: pgsql-admin
scheams work fine in ONE db, I need to have two databass and they need to able to talk to eacher, dblink funciton is working fine for me now, I am just wondering if there is any other better way than dblink...
Thanks,
Jessica
Scott Marlowe <smarlowe@g2switchworks.com> wrote: Jessica Richard wrote:
> Other than dblink, is there any other way to let me joint select two
> tables in two different databases?
Would schemas work for you? You can have multiple schemas in one
database (like oracle) so that you references tables as
schemaname.tablename etc... Works well for most places you need to do this.
---------------------------------
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2007-05-18 17:28 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-28 15:05 Cross-database references Sidar Lopez Cruz <sidarlopez@hotmail.com>
2003-02-28 16:31 ` Tycho Fruru <tycho@fruru.com>
2003-02-28 20:47 ` Ian Barwick <barwick@gmx.net>
2003-02-28 22:17 ` Robert Treat <xzilla@users.sourceforge.net>
2007-05-18 13:26 cross database references... Jessica Richard <rjessil@yahoo.com>
2007-05-18 14:24 ` Re: cross database references... Joshua D. Drake <jd@commandprompt.com>
2007-05-18 15:59 ` Re: cross database references... Scott Marlowe <smarlowe@g2switchworks.com>
2007-05-18 17:28 ` Re: cross database references... Jessica Richard <rjessil@yahoo.com>
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