-- bigistore binary_copy should copy data out and in again using binary format; CREATE TABLE before_bigistore (a bigistore); INSERT INTO before_bigistore values ('1=>1'),('1=>-9223372036854775807'),('1=>3'),('2=>1'),('2=>0'),('2=>9223372036854775806'); CREATE TABLE after_bigistore (a bigistore); COPY before_bigistore TO '/tmp/tst' WITH (FORMAT binary); COPY after_bigistore FROM '/tmp/tst' WITH (FORMAT binary); SELECT * FROM after_bigistore; a ----------------------------- "1"=>"1" "1"=>"-9223372036854775807" "1"=>"3" "2"=>"1" "2"=>"0" "2"=>"9223372036854775806" (6 rows) -- istore binary_copy should copy data out and in again using binary format; CREATE TABLE before_istore (a istore); INSERT INTO before_istore values ('1=>1'),('1=>-2147483647'),('1=>3'),('2=>1'),('2=>0'),('2=>2147483647'); CREATE TABLE after_istore (a istore); COPY before_istore TO '/tmp/tst' WITH (FORMAT binary); COPY after_istore FROM '/tmp/tst' WITH (FORMAT binary); SELECT * FROM after_istore; a -------------------- "1"=>"1" "1"=>"-2147483647" "1"=>"3" "2"=>"1" "2"=>"0" "2"=>"2147483647" (6 rows)