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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
