CREATE DATABASE db_gbk_test TEMPLATE template0 encoding 'GBK' lc_ctype 'zh_CN.GBK' lc_collate 'zh_CN.GBK';
\c db_gbk_test
create table t (id int,c varchar);
insert into t values (1,'测试');
insert into t values (2,'测试�\');
insert into t values (3,'测试3�\测试4');
insert into t values (4,'�\测试4');
insert into t values (5,'�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�[�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\�\');

create table t_stdin (id int,c varchar);
create table t_csv (id int,c varchar);
create table t_text (id int,c varchar);
create table t_fixed (id int,c varchar);
create table t_binary (id int,c varchar);

COPY t TO '@abs_srcdir@/data/datanode1/t_csv.data' WITH(FORMAT 'csv');
COPY t TO '@abs_srcdir@/data/datanode1/t_text.data' WITH(FORMAT 'text');
COPY t TO '@abs_srcdir@/data/datanode1/t_fixed.data' fixed formatter(id(0,2), c(2,300));
COPY t TO '@abs_srcdir@/data/datanode1/t_binary.data' WITH(FORMAT 'binary');

COPY t_csv FROM '@abs_srcdir@/data/datanode1/t_csv.data' WITH(FORMAT 'csv');
COPY t_text FROM '@abs_srcdir@/data/datanode1/t_text.data' WITH(FORMAT 'text');
COPY t_fixed FROM '@abs_srcdir@/data/datanode1/t_fixed.data' fixed formatter(id(0,2), c(2,300));
COPY t_binary FROM '@abs_srcdir@/data/datanode1/t_binary.data' WITH(FORMAT 'binary');

SELECT * FROM t;
SELECT * FROM t_csv;
SELECT * FROM t_text;
SELECT * FROM t_fixed;
SELECT * FROM t_binary;

\d t;
\d t_csv;
\d t_text;
\d t_fixed;
\d t_binary;