'Tests altering columns with multiple words in Postgres types (issue #125)
e.g. \'datetime with time zone\', look at django/db/backends/postgresql/creation.py'

def test_alter_column_postgres_multiword(self):

    db.create_table('test_multiword', [('col_datetime', models.DateTimeField(null=True)), ('col_integer', models.PositiveIntegerField(null=True)), ('col_smallint', models.PositiveSmallIntegerField(null=True)), ('col_float', models.FloatField(null=True))])
    db.alter_column('test_multiword', 'col_float', models.FloatField('float', null=True))
    db.alter_column('test_multiword', 'col_integer', models.PositiveIntegerField(null=True))
    db.alter_column('test_multiword', 'col_smallint', models.PositiveSmallIntegerField(null=True))
    if (db.backend_name == 'postgres'):
        db.execute("INSERT    INTO    test_multiword    (col_datetime)    VALUES    ('2009-04-24    14:20:55+02')")
        db.alter_column('test_multiword', 'col_datetime', models.DateTimeField(auto_now=True))
        assert db.execute("SELECT    col_datetime    =    '2009-04-24    14:20:55+02'    FROM    test_multiword")[0][0]
    db.delete_table('test_multiword')
