pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Cross-database references
8+ messages / 7 participants
[nested] [flat]

* Cross-database references
@ 2003-02-28 15:05 Sidar Lopez Cruz <sidarlopez@hotmail.com>
  2003-02-28 16:31 ` Re: Cross-database references Tycho Fruru <tycho@fruru.com>
  2003-02-28 20:47 ` Re: Cross-database references Ian Barwick <barwick@gmx.net>
  2003-02-28 22:17 ` Re: Cross-database references Robert Treat <xzilla@users.sourceforge.net>
  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 15:05 Cross-database references Sidar Lopez Cruz <sidarlopez@hotmail.com>
@ 2003-02-28 16:31 ` Tycho Fruru <tycho@fruru.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 15:05 Cross-database references Sidar Lopez Cruz <sidarlopez@hotmail.com>
@ 2003-02-28 20:47 ` Ian Barwick <barwick@gmx.net>
  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 15:05 Cross-database references Sidar Lopez Cruz <sidarlopez@hotmail.com>
@ 2003-02-28 22:17 ` Robert Treat <xzilla@users.sourceforge.net>
  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>
  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>
  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 13:26 cross database references... Jessica Richard <rjessil@yahoo.com>
@ 2007-05-18 14:24 ` Joshua D. Drake <jd@commandprompt.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 13:26 cross database references... Jessica Richard <rjessil@yahoo.com>
@ 2007-05-18 15:59 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2007-05-18 17:28   ` Re: cross database references... 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 13:26 cross database references... Jessica Richard <rjessil@yahoo.com>
  2007-05-18 15:59 ` Re: cross database references... Scott Marlowe <smarlowe@g2switchworks.com>
@ 2007-05-18 17:28   ` Jessica Richard <rjessil@yahoo.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