copy table from postgresql to mysql
sqlpipe transfer
--source-ds-type "postgresql"
--source-hostname "your-postgresql-hostname"
--source-port 5432
--source-db-name "your-postgresql-db-name"
--source-username "your-postgresql-username"
--source-password "your-postgresql-password"
--target-ds-type "mysql"
--target-hostname "your-mysql-hostname"
--target-port 3306
--target-db-name "your-mysql-db-name"
--target-username "your-mysql-username"
--target-password "your-mysql-password"
--target-table "name-of-table-to-insert-into"
--overwrite
--query "select * from public.users"