BEGIN;
-- bigistore binary_copy should copy data binary from country;
-- ./spec/istore/binary_copy_spec.rb:9;
CREATE EXTENSION istore;
CREATE TABLE before (a bigistore);
INSERT INTO before values ('1=>1'),('1=>-9223372036854775807'),('1=>3'),('2=>1'),('2=>0'),('2=>9223372036854775806');
CREATE TABLE after (a bigistore);
COPY before TO '/tmp/tst' WITH (FORMAT binary);
COPY after FROM '/tmp/tst' WITH (FORMAT binary);
SELECT * FROM after;
              a              
-----------------------------
 "1"=>"1"
 "1"=>"-9223372036854775807"
 "1"=>"3"
 "2"=>"1"
 "2"=>"0"
 "2"=>"9223372036854775806"
(6 rows)

ROLLBACK;
BEGIN;
-- istore binary_copy should copy data binary from country;
-- ./spec/istore/binary_copy_spec.rb:9;
CREATE EXTENSION istore;
CREATE TABLE before (a istore);
INSERT INTO before values ('1=>1'),('1=>-2147483647'),('1=>3'),('2=>1'),('2=>0'),('2=>2147483647');
CREATE TABLE after (a istore);
COPY before TO '/tmp/tst' WITH (FORMAT binary);
COPY after FROM '/tmp/tst' WITH (FORMAT binary);
SELECT * FROM after;
         a          
--------------------
 "1"=>"1"
 "1"=>"-2147483647"
 "1"=>"3"
 "2"=>"1"
 "2"=>"0"
 "2"=>"2147483647"
(6 rows)

ROLLBACK;