importing data from other DB's and from other servers - Mailing list pgsql-sql

-----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-----