Home > mailing lists

DB Link Question - Mailing list pgsql-general

From	Alex -
Subject	DB Link Question
Date	December 28, 2009 17:32:26
Msg-id	SNT135-w483B1B0609433FE0BC10DFCF7B0@phx.gbl Whole thread Raw
List	pgsql-general

Hi,

is there away to check with DB Link if one record exists/not exists in a remote database?

Something like...

SELECT item_id FROM TABLE A WHERE NOT EXISTS (SELECT 1 FROM TABLE B WHERE A.item_id=B.item_id)

Where Table A is on a Local machine and Table B is on a remote machine.

Thanks for any help on that.

Alex

From: Mark Williamson
Date: 28 December 2009, 16:27:18
Subject: unsubscribe remove

From: Ivan Sergio Borgonovo
Date: 28 December 2009, 17:42:12
Subject: pg_dump excluding tables content but not table schema