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// ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/