On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote:
> Ok, tried to run:
>
> alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8
>
> But I just get:
>
> [Error Code: 0, SQL State: 42601] ERROR: syntax error at or near "varchar"
> (tried without the varchar also..)
ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE
collation ] [ USING expression ]
You need to add the TYPE key word, I think.
Oliver Elphick