drop database if exists export;

create database export encoding='gbk' LC_COLLATE='zh_CN.GBK' LC_CTYPE ='zh_CN.GBK' TEMPLATE=template0;

--other seesion set up and quit quickly
\! @gsqldir@/gsql -dexport -p @portstring@ -c '\q'
--multi bytes
select upper('abc数据表');
select lower('abc数据表');
drop database export;