Guest User

Untitled

a guest
Oct 20th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
  2. SELECT a, b, network(c) FROM dblink('host=xxx user=xxx password=xxx dbname=xxx', 'SELECT ipp_id, res_id, ipp_ipcidr FROM public.ipplage')
  3. AS x(a integer, b integer, c cidr)
  4.  
  5. INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
  6. SELECT a, b, network(c) FROM dblink('host=xxx user=xxx password=xxx dbname=xxx', 'SELECT ipp_id, res_id, ipp_ipcidr::inet::cidr FROM public.ipplage')
  7. AS x(a integer, b integer, c cidr)
  8.  
  9. INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
  10. SELECT a, b, network(c) FROM dblink('host=xxx user=xxx password=xxx dbname=xxx', 'SELECT ipp_id, res_id, ipp_ipcidr FROM public.ipplage')
  11. AS x(a integer, b integer, c inet)
Add Comment
Please, Sign In to add comment