From 220f24bb47121360621a6848030904d6098215b7 Mon Sep 17 00:00:00 2001
From: Marco Nenciarini <marco.nenciarini@devise.it>
Date: Sat, 5 Dec 2009 01:45:47 +0800
Subject: [PATCH] Added support for char datatype

---
 mysql2psql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/mysql2psql b/mysql2psql
index 6a2f2ac..4eb9aad 100755
--- a/mysql2psql
+++ b/mysql2psql
@@ -38,6 +38,8 @@ class MysqlReader
         "integer"
       when /varchar/
         "varchar"
+      when /char/
+        "char"
       when /decimal/
         "decimal"
       else
@@ -193,6 +195,9 @@ class PostgresWriter < Writer
     null = column[:null] ? "" : " NOT NULL"
     type = 
     case column[:type]
+    when "char"
+      default = default + "::char" if default
+      "character(#{column[:length]})"
     when "varchar"
       default = default + "::character varying" if default
 #      puts "VARCHAR: #{column.inspect}"
-- 
2.1.4