| From: | Alex - <aintokyo(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | DB Link Question |
| Date: | 2009-12-28 18:31:07 |
| Message-ID: | SNT135-w483B1B0609433FE0BC10DFCF7B0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
_________________________________________________________________
A world FIRST in property search has arrived! Check out Domain Radar NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2009-12-28 18:41:36 | pg_dump excluding tables content but not table schema |
| Previous Message | Mark Williamson | 2009-12-28 17:11:00 | unsubscribe remove |