Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO partitions.accounts_providers_2(id_account, id_provider, id_at_provider, period, control_string)
- SELECT _accounts_id_to_save, _accounts_id_provider_to_save, _accounts_id_at_provider, '2',
- ('"_streets_city"=>"' || _streets_city || '", "_accounts_name"=>"' || _accounts_name
- || '", "_accounts_phone"=>"' || _accounts_phone || '", "_streets_street"=>"' || _streets_street
- || '", "_accounts_surname"=>"' || _accounts_surname || '", "_houses_house_num"=>"' || _houses_house_num
- || '", "_accounts_flat_num"=>"' || _accounts_flat_num || '", "_streets_city_type"=>"'
- || _streets_city_type || '", "_houses_house_block"=>"' || _houses_house_block
- || '", "_houses_house_liter"=>"' || _houses_house_liter || '", "_accounts_flat_liter"=>"'
- || _accounts_flat_liter || '", "_accounts_middlename"=>"' || _accounts_middlename
- || '", "_streets_street_type"=>"' || _streets_street_type || '", "_accounts_count_rooms"=>"'
- || CASE WHEN _accounts_count_rooms IS NOT NULL THEN _accounts_count_rooms::character varying ELSE ''::character varying END
- || '", "_accounts_count_people"=>"'
- || CASE WHEN _accounts_count_people IS NOT NULL THEN _accounts_count_people::character varying ELSE ''::character varying END
- || '", "_accounts_square_total"=>"'
- || CASE WHEN _accounts_square_total IS NOT NULL THEN _accounts_square_total::character varying ELSE ''::character varying END
- || '", "_accounts_square_heated"=>"'
- || CASE WHEN _accounts_square_heated IS NOT NULL THEN _accounts_square_heated::character varying ELSE ''::character varying END
- || '", "_accounts_square_living"=>"'
- || CASE WHEN _accounts_square_living IS NOT NULL THEN _accounts_square_living::character varying ELSE ''::character varying END
- || '"')::hstore
- FROM uploads."2011-12-08-15-04-16-420"
Add Comment
Please, Sign In to add comment