Postgres character columns are not treated as string types

[drewbanin]

Issue

Issue description

dbt does not treat character types as string types, and therefore leaves out the length portion of the character column type when building columns. This happens during Archival (and likely incremental models when expanding types) on Postgres.

Results

dbt should treat character as a string type, as with varchar and text.

System information

The output of dbt --version:

0.12.x

Steps to reproduce

Archive a table on Postgres with a column of type character(36). dbt will recreate this column with type character with no size specified.

This issue was created from the description of #1191