One table into two different databases

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

On 11/08/2003 17: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.

Have you looked at dblink?

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+