Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT A.nodo,
- B.nodo
- FROM camper.public.camper1 A
- INNER JOIN camper_tmp.public.campi2c B
- ON A.nodo= B.nodo
- Base de datos: tabla2
- usuario: postgres
- password: 123456
- create extension dblink;
- select T1.campo1, T1.campo2..., T2.campo1, T2.campo2, ...
- from tabla1 T1, dblink('dbname=test2 user=postgres password=123456', 'select * from tabla2') as T2 (campo1 tipo1, campo2 tipo2, ...)
- where condiciones
Add Comment
Please, Sign In to add comment