One table into two different databases

[Marcelo Soares]

Hi all,

I would like to know if its possible to have the SAME TABLE into two
different databases (but in the same server). Or to create a view of a
table of database X at the database Y.

I try to find it in Postgres docs, with no success.

Thanks to all,

Marcelo

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Jonathan Gardner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 11 August 2003 09:32, Marcelo Soares wrote:

Hi all,

I would like to know if its possible to have the SAME TABLE into two
different databases (but in the same server). Or to create a view of a
table of database X at the database Y.

I try to find it in Postgres docs, with no success.

Trying running in one database with multiple schemas.

- --
Jonathan Gardner <jg******@jonathangardner.net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/N/QIWgwF3QvpWNwRArJdAKCobIj8Ti/KZ+ORxHM6Qz5f+sM9dACgxIU7
QBtMhtcYwOkxz8x4DqNnt+Q=
=sXTu
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org