PostgreSQL Extract and Load using COPY

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>PostgreSQL Extract and Load using COPY</name>
     <script>postgres_extract_load</script>
     <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <tasks>
          
          <task>
               <name>drop_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
               <sql>
                   DROP TABLE employee_stage;
               </sql>
               <onexception action="ignore"/>               
          </task>

<task>
               <name>create_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
               <sql>
                   create TABLE employee_stage
                   (
                     EMPNO	CHAR(6)	not null,
                     FIRSTNME	VARCHAR(12)	not null,
                     MIDINIT	CHAR(1),
                     LASTNAME	VARCHAR(15)	not null,
                     WORKDEPT	CHAR(3),	
                     PHONENO	CHAR(4),	
                     HIREDATE	DATE,	
                     JOB	CHAR(8)	
                   );
               </sql>
          </task>

<task>
               <name>extract</name>
               <connection>source</connection>
               <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   COPY (select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from employee) TO '{DATA_FOLDER}emp.txt' WITH DELIMITER ';';
               </sql>
          </task>

<task>
               <name>load</name>
               <connection>dest</connection>
               <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   copy employee_stage from '{DATA_FOLDER}emp.txt' WITH DELIMITER ';';
               </sql>
          </task>
          
     </tasks>
     
     <destinations>
          <destination>
               <name>employee_table</name>
               <metadata>true</metadata>
               <cursor table="employee_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>