Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. psql -h localhost -p 5433 -U postgres iescolar
  2.  
  3. SELECT dblink_connect('conexao','host=localhost port=5433 user=postgres dbname=novoiescolar password=123456');
  4.  
  5. SELECT p.id FROM aluno p WHERE p.id NOT IN (SELECT a.id FROM dblink('conexao', 'Select id from aluno') AS a (id INT));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement