Re: One table into two different databases

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: One table into two different databases
Date: 2003-08-11 22:12:14
Message-ID: 20030811231214.I26973@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Mariani 2003-08-11 22:12:35 Re: public key functions for postgresql ?
Previous Message Bruce Momjian 2003-08-11 21:44:19 Re: PostgreSQL