Postgres Pro
Downloads
Home   >   mailing lists

Thread: One table into two different databases

One table into two different databases

From
"Marcelo Soares"
Date:
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

Re: One table into two different databases

From
Jonathan Gardner
Date:
-----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-----

Re: One table into two different databases

From
Paul Thomas
Date:
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   |
+------------------------------+---------------------------------------------+