pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMultiple Databases
9+ messages / 7 participants
[nested] [flat]
* Multiple Databases
@ 2002-10-23 07:50 peter <peter@peter.com>
2002-10-23 16:31 ` Re: Multiple Databases Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 9+ messages in thread
From: peter @ 2002-10-23 07:50 UTC (permalink / raw)
To: pgsql-sql
Is it possible to create a view using tables from two different postgresql
servers?
Thanks
Peter
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Multiple Databases
2002-10-23 07:50 Multiple Databases peter <peter@peter.com>
@ 2002-10-23 16:31 ` Josh Berkus <josh@agliodbs.com>
2002-10-23 16:36 ` Re: Multiple Databases Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 9+ messages in thread
From: Josh Berkus @ 2002-10-23 16:31 UTC (permalink / raw)
To: peter <peter@peter.com>; pgsql-sql
Peter,
> Is it possible to create a view using tables from two different
> postgresql
> servers?
No.
-Josh Berkus
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Multiple Databases
2002-10-23 07:50 Multiple Databases peter <peter@peter.com>
2002-10-23 16:31 ` Re: Multiple Databases Josh Berkus <josh@agliodbs.com>
@ 2002-10-23 16:36 ` Joe Conway <mail@joeconway.com>
2002-10-24 06:42 ` Re: Multiple Databases peter <peter@peter.com>
0 siblings, 1 reply; 9+ messages in thread
From: Joe Conway @ 2002-10-23 16:36 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: peter <peter@peter.com>; pgsql-sql
Josh Berkus wrote:
>>Is it possible to create a view using tables from two different
>>postgresql
>>servers?
>
> No.
>
It isn't possible with plain old SQL, but it is possible (albeit ugly) using
contrib/dblink in PostgreSQL 7.2.x. See README.dblink for documentation and
examples.
In PostgreSQL 7.3 (in beta testing now) the syntax and usability of
contrib/dblink is greatly improved.
Joe
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Multiple Databases
2002-10-23 07:50 Multiple Databases peter <peter@peter.com>
2002-10-23 16:31 ` Re: Multiple Databases Josh Berkus <josh@agliodbs.com>
2002-10-23 16:36 ` Re: Multiple Databases Joe Conway <mail@joeconway.com>
@ 2002-10-24 06:42 ` peter <peter@peter.com>
0 siblings, 0 replies; 9+ messages in thread
From: peter @ 2002-10-24 06:42 UTC (permalink / raw)
To: pgsql-sql
thanks for your help guys.
Peter
"Joe Conway" <mail@joeconway.com> wrote in message
news:3DB6D01C.9000601@joeconway.com...
> Josh Berkus wrote:
> >>Is it possible to create a view using tables from two different
> >>postgresql
> >>servers?
> >
> > No.
> >
>
> It isn't possible with plain old SQL, but it is possible (albeit ugly)
using
> contrib/dblink in PostgreSQL 7.2.x. See README.dblink for documentation
and
> examples.
>
> In PostgreSQL 7.3 (in beta testing now) the syntax and usability of
> contrib/dblink is greatly improved.
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
^ permalink raw reply [nested|flat] 9+ messages in thread
* multiple databases
@ 2002-10-26 05:15 peter <peter@peter.com>
2002-10-28 14:21 ` Re: multiple databases Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 9+ messages in thread
From: peter @ 2002-10-26 05:15 UTC (permalink / raw)
To: pgsql-sql
I need to create a recordset in vb which combines a view/table from 2
different databases. Is this possible? in mssql you could go
dbo.databasename.tablename. Can it be done in vb code?
Thanks for any help
Peter
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: multiple databases
2002-10-26 05:15 multiple databases peter <peter@peter.com>
@ 2002-10-28 14:21 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 9+ messages in thread
From: Roberto Mello @ 2002-10-28 14:21 UTC (permalink / raw)
To: peter <peter@peter.com>; +Cc: pgsql-sql
On Sat, Oct 26, 2002 at 03:15:18PM +1000, peter wrote:
> I need to create a recordset in vb which combines a view/table from 2
> different databases. Is this possible? in mssql you could go
> dbo.databasename.tablename. Can it be done in vb code?
There's an extension to PostgreSQL, called dblink, that allows it. Look at
the contrib tree on the PostgreSQL archives.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
"Data! I thought you were dead!" "No, Sir. I rebooted."
^ permalink raw reply [nested|flat] 9+ messages in thread
* Multiple databases
@ 2008-04-16 06:59 Sumaya <sumaya@silvermoongroup.com>
2008-04-16 07:24 ` Re: Multiple databases A. Kretschmer <andreas.kretschmer@schollglas.com>
2008-04-16 12:01 ` Re: Multiple databases Gerardo Herzig <gherzig@fmed.uba.ar>
0 siblings, 2 replies; 9+ messages in thread
From: Sumaya @ 2008-04-16 06:59 UTC (permalink / raw)
To: pgsql-sql
Hi,
I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases, how do I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work. Any ideas?
Thanks,
Sumaya
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Multiple databases
2008-04-16 06:59 Multiple databases Sumaya <sumaya@silvermoongroup.com>
@ 2008-04-16 07:24 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
1 sibling, 0 replies; 9+ messages in thread
From: A. Kretschmer @ 2008-04-16 07:24 UTC (permalink / raw)
To: pgsql-sql
am Wed, dem 16.04.2008, um 8:59:46 +0200 mailte Sumaya folgendes:
> Hi,
>
> I am converting sql code from sql server to postgresql. Data is currently
> being retrieved from multiple databases, how do I do this using postgresql. I
> have tried using eg. select * from datbasename.tablename but this does not
> work. Any ideas?
You can use multiple databases, but you can't work across multiple
databases. PostgreSQL offers schemas, you can use them.
http://www.postgresql.org/docs/current/static/ddl-schemas.html
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Multiple databases
2008-04-16 06:59 Multiple databases Sumaya <sumaya@silvermoongroup.com>
@ 2008-04-16 12:01 ` Gerardo Herzig <gherzig@fmed.uba.ar>
1 sibling, 0 replies; 9+ messages in thread
From: Gerardo Herzig @ 2008-04-16 12:01 UTC (permalink / raw)
To: Sumaya <sumaya@silvermoongroup.com>; pgsql-sql
Sumaya wrote:
>Hi,
>
>I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases, how do I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work. Any ideas?
>
>Thanks,
>Sumaya
>
>
Are you saying that you want a particular function stored in say
database A to be able to retrieve some data from dabatase X?
If that so, you may take a look to the dblink contrib package.
Gerardo
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2008-04-16 12:01 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-23 07:50 Multiple Databases peter <peter@peter.com>
2002-10-23 16:31 ` Josh Berkus <josh@agliodbs.com>
2002-10-23 16:36 ` Joe Conway <mail@joeconway.com>
2002-10-24 06:42 ` peter <peter@peter.com>
2002-10-26 05:15 multiple databases peter <peter@peter.com>
2002-10-28 14:21 ` Re: multiple databases Roberto Mello <rmello@cc.usu.edu>
2008-04-16 06:59 Multiple databases Sumaya <sumaya@silvermoongroup.com>
2008-04-16 07:24 ` Re: Multiple databases A. Kretschmer <andreas.kretschmer@schollglas.com>
2008-04-16 12:01 ` Re: Multiple databases Gerardo Herzig <gherzig@fmed.uba.ar>
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