Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
- 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')
- AS x(a integer, b integer, c cidr)
- INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
- 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')
- AS x(a integer, b integer, c cidr)
- INSERT INTO ip.cidr (cid_id, cid_res_id, cid_cidr)
- 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')
- AS x(a integer, b integer, c inet)
Add Comment
Please, Sign In to add comment