test: Complete test for all Postgres supported types

[chesedo]

Adds tests for all the current types supported by Postgres to test both generating and importing. This work uncovered a number of bugs:

• 269

• 270

• 271

• 272

[christos-h]

Great stuff @chesedo - thanks!