On Fri, 2007-09-07 at 10:16 +0200, Albe Laurenz wrote:
> Ow Mun Heng wrote:
> True, you'll have to write some stuff that does something like:
> - pull the data over from the other database
> - replace the data in the local table
Already doing that currently for some data tables/
> Since it is between PostgreSQL databases,
actually, it'll be against SQL Servers
> preserves less of the PostgreSQL-ness
> of the data - e.g. data type is lost, all data arrive as text.
Another thing I didn't know.. thanks again for this heads up..
> The correct way is like this:
> cd into the PostgreSQL source directory
> ./configure with the correct arguments
> make -C src/backend ../../src/include/utils/fmgroids.h
> make -C contrib/dblink
Cool. I'll give it a shot//