TMACUL

Carga Estados Brasileiros / Brazilian State load - ca_state_province

Blog Post created by TMACUL Champion on Jun 18, 2015

pdm_load -a -v -f estados.txt

 

 

estados.txt

TABLE ca_state_province

  creation_date creation_user delete_time description exclude_registration

  id inactive last_update_date last_update_user symbol version_number

  { "06/18/2015 12:00:32" ,"CASMAdmin" ,"" ,"Acre" ,"" ,"1000016" ,"0",

  "06/18/2015 12:00:50" ,"CASMAdmin" ,"AC" ,"1" }

  { "" ,"" ,"" ,"Alagoas\\0012\\0012Antigo - Alabama" ,"" ,"7401" ,"0",

  "06/18/2015 12:12:52" ,"CASMAdmin" ,"AL" ,"1" }

  { "06/18/2015 12:01:52" ,"CASMAdmin" ,"" ,"Amazonas" ,"" ,"1000018" ,"0",

  "06/18/2015 12:01:59" ,"CASMAdmin" ,"AM" ,"1" }

  { "06/18/2015 12:00:53" ,"CASMAdmin" ,"" ,"Amapá" ,"" ,"1000017" ,"0",

  "06/18/2015 12:01:49" ,"CASMAdmin" ,"AP" ,"2" }

  { "06/18/2015 12:02:08" ,"CASMAdmin" ,"" ,"Bahia" ,"" ,"1000019" ,"0",

  "06/18/2015 12:02:16" ,"CASMAdmin" ,"BA" ,"1" }

  { "06/18/2015 12:02:46" ,"CASMAdmin" ,"" ,"Ceará" ,"" ,"1000021" ,"0",

  "06/18/2015 12:02:53" ,"CASMAdmin" ,"CE" ,"1" }

  { "06/18/2015 12:02:46" ,"CASMAdmin" ,"" ,"Distrito Fedeal" ,"",

  "1000020" ,"0" ,"06/18/2015 12:03:22" ,"CASMAdmin" ,"DF" ,"1" }

  { "06/18/2015 12:13:22" ,"CASMAdmin" ,"" ,"Espírito Santo" ,"",

  "1000032" ,"0" ,"06/18/2015 12:13:32" ,"CASMAdmin" ,"ES" ,"1" }

  { "06/18/2015 12:04:23" ,"CASMAdmin" ,"" ,"Goiás" ,"" ,"1000022" ,"0",

  "06/18/2015 12:04:30" ,"CASMAdmin" ,"GO" ,"1" }

  { "" ,"" ,"" ,"Maranhão" ,"" ,"7419" ,"0" ,"06/18/2015 12:14:41",

  "CASMAdmin" ,"MA" ,"1" }

  { "06/18/2015 11:56:36" ,"CASMAdmin" ,"" ,"Minas Gerais" ,"" ,"1000012",

  "0" ,"06/18/2015 11:56:49" ,"CASMAdmin" ,"MG" ,"1" }

  { "" ,"" ,"" ,"Mato Grosso do Sul\\0012Mississippi" ,"" ,"7425" ,"0",

  "06/18/2015 12:22:15" ,"CASMAdmin" ,"MS" ,"1" }

  { "" ,"" ,"" ,"Mato Grosso\\0012Montana" ,"" ,"7426" ,"0",

  "06/18/2015 12:15:04" ,"CASMAdmin" ,"MT" ,"1" }

  { "" ,"" ,"" ,"Pará\\0012Pensilvânia" ,"" ,"7438" ,"0",

  "06/18/2015 12:15:50" ,"CASMAdmin" ,"PA" ,"1" }

  { "06/18/2015 12:05:57" ,"CASMAdmin" ,"" ,"Paraíba" ,"" ,"1000024" ,"0",

  "06/18/2015 12:07:17" ,"CASMAdmin" ,"PB" ,"3" }

  { "06/18/2015 12:07:34" ,"CASMAdmin" ,"" ,"Pernambuco" ,"" ,"1000025",

  "0" ,"06/18/2015 12:07:58" ,"CASMAdmin" ,"PE" ,"1" }

  { "06/18/2015 12:08:51" ,"CASMAdmin" ,"" ,"PIauí" ,"" ,"1000026" ,"0",

  "06/18/2015 12:08:59" ,"CASMAdmin" ,"PI" ,"1" }

  { "" ,"" ,"" ,"Paraná\\0012Porto Rico" ,"" ,"7464" ,"0",

  "06/18/2015 12:16:16" ,"CASMAdmin" ,"PR" ,"1" }

  { "06/18/2015 11:56:20" ,"CASMAdmin" ,"" ,"Rio de Janeiro" ,"" ,"1000011",

  "0" ,"06/18/2015 11:56:30" ,"CASMAdmin" ,"RJ" ,"1" }

  { "06/18/2015 12:09:19" ,"CASMAdmin" ,"" ,"Rio Grande do Norte" ,"",

  "1000027" ,"0" ,"06/18/2015 12:09:27" ,"CASMAdmin" ,"RN" ,"1" }

  { "06/18/2015 12:09:39" ,"CASMAdmin" ,"" ,"Rôndônia" ,"" ,"1000028",

  "0" ,"06/18/2015 12:10:15" ,"CASMAdmin" ,"RO" ,"1" }

  { "06/18/2015 12:10:24" ,"CASMAdmin" ,"" ,"Roraima" ,"" ,"1000029" ,"0",

  "06/18/2015 12:10:29" ,"CASMAdmin" ,"RR" ,"1" }

  { "06/18/2015 11:59:14" ,"CASMAdmin" ,"" ,"Rio Grande do sul" ,"",

  "1000015" ,"0" ,"06/18/2015 11:59:25" ,"CASMAdmin" ,"RS" ,"1" }

  { "" ,"" ,"" ,"Santa Catarina\\0012Carolina do Sul" ,"" ,"7440" ,"0",

  "06/18/2015 12:23:52" ,"CASMAdmin" ,"SC" ,"1" }

  { "06/18/2015 12:10:57" ,"CASMAdmin" ,"" ,"Sergipe" ,"" ,"1000030" ,"0",

  "06/18/2015 12:11:28" ,"CASMAdmin" ,"SE" ,"1" }

  { "06/18/2015 11:50:20" ,"CASMAdmin" ,"" ,"São Paulo" ,"" ,"1000010",

  "0" ,"06/18/2015 11:50:37" ,"CASMAdmin" ,"SP" ,"1" }

  { "06/18/2015 12:11:31" ,"CASMAdmin" ,"" ,"Tocantins" ,"" ,"1000031" ,"0",

  "06/18/2015 12:11:39" ,"CASMAdmin" ,"TO" ,"1" }

 

Download Files:

 

 

---------------------------------

Author: Tiago Macul

Tiago MACUL's Blog


---------------------------------

Outcomes