PostgreSQL to C# POCO

PgsqlToPoco.cs

void Main()
{
    // 1. Generate CREATE TABLE command for the existing table.
    // 2. Select only text with the columns definitions and copy to the Clipboard.
    // 3. Run the code below. C# properties will be in the Clipboard.

    var sql = Clipboard.GetText();
    var exclusions = new[] { "primary key", "constraint .*", "unique" };

    var typeMapping = new Dictionary<string, string>
                      {
                          { "integer", "int" },
                          { "integer?", "int?" },
                          { "varchar", "string" },
                          { "varchar?", "string" },
                          { "boolean", "bool" },
                          { "boolean?", "bool?" },
                          { "timestamp", "DateTime" },
                          { "timestamp?", "DateTime?" },
                          { "date", "DateTime" },
                          { "date?", "DateTime?" }
                      };

    string toProperty(Match columnMatch)
    {
        var name = columnMatch.Groups["name"].Value;

        var sqlType = columnMatch.Groups["type"].Value;
        var isNullable = !columnMatch.Groups["not_null"].Success;

        var type = typeMapping[sqlType + (isNullable ? "?" : "")];

        return $"public {type} {name} {{ get; set; }}";
    }

    var poco = Regex.Matches(sql, @"(?<name>\w+) (?<type>\w+)\(?\d*\)?\s?(?<not_null>not null)?")
                    .Cast<Match>()
                    .Where(m => exclusions.All(e => !Regex.IsMatch(m.Value, e)))
                    .Select(m => toProperty(m));

    var cs = string.Join("\r\n\r\n", poco);
    Clipboard.SetText(cs);
}