Received: from neptuno.sc.uevora.pt (neptuno.sc.uevora.pt [193.136.216.24]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA15406 for ; Wed, 13 May 1998 14:39:20 -0400 (EDT) Received: (from mjnf@localhost) by neptuno.sc.uevora.pt (8.8.5/8.8.5) id TAA08771 for pgsql-sql@postgresql.org; Wed, 13 May 1998 19:39:08 +0100 Message-ID: X-Mailer: XFMail 1.3-alpha-021598 [p0] on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit MIME-Version: 1.0 Date: Wed, 13 May 1998 19:39:08 +0100 (WEST) X-Face: "9hSo9W{D!]@5,5u$o~%u; Y'Jd-soHe$zeqc1MFu&mlE; af,Hbz}V,Le1_5)/fK@@P/#_+, `6TSkyHf39(-wxNK9gi$Oin`[S|xWBJ0T8gQ, m[h$1b?1"}SEpxt+:H-m+%h7|Wy)hM-3, cbg3Y8Y> YJIYJu= Reply-To: mjnf@uevora.pt Organization: Universidade de Evora Sender: mjnf@neptuno.sc.uevora.pt From: Mario Filipe To: pgsql-sql@postgresql.org Subject: importing data from other DB's and from other servers -----BEGIN PGP SIGNED MESSAGE----- Hi First of all i want to apologize if this is the wrong list, but here goes: Suppose i have to DB's on the same server. Is there a way (maybe with views) that i can have one table from one of the DB's into the other. Ex: DB 1 table A table B DB 2 table C table B (this one is a pointer to table B in DB 1) Is this possible ??? What about doing this but with the db's on different server's. I thought about creating a view where the select would be a c function (or an internal one, haven't looked at it yet) that would select what i want from the other db. Is this possible ? How ? Will it ever be possible ? When ? Thanks Mario Filipe mjnf@uevora.pt http://neptuno.sc.uevora.pt/~mjnf -----BEGIN PGP SIGNATURE----- Version: 2.6.3ia Charset: noconv iQEVAwUBNVnoypiyznf+xIrhAQF3Jwf9E4Ey0whuOW1UVngrGBtQrreMqAnbckf9 wlJa/KHA8QUCnghd++GeIJIMkcWxO0oG0Cja3ybZIh+TwBXEndQa7WokrJfgzfhS wo6suqtOSSPPvqKlsEgSGUF+uVzRcKelo9Rb4eW1hCuziwxJhYNSUJ0jrcV3wB/X Hmzv4Hdy0pxpRbPgKDofbebzv61d4FOfHPIOT5VYR86Xs0XB7Ef2oE13hxX3oigK KHfP41xhYMbdK5OZf8IwkRmFXMcbdamevn/y1iyOsxQ3Lxpw5VkSBR6wQayfU1ck mdpfLDdeq3kPGccnX3+3w+H8O6AakChyeRGSSVAwx8W6iqzEPbCJKQ== =v3n3 -----END PGP SIGNATURE-----