Re: One table into two different databases

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