postgresql: whats wrong in my sql statement of altering a column in a table

Question

I am trying to alter a tables column with a default value of -11 and it can be null

ALTER TABLE devicedata ALTER COLUMN "weather" smallint NULL DEFAULT -11 ;

it says error

GMB · Accepted Answer · 2020-12-20 01:30:56Z

1

In Postgres the syntax for this is:

alter table device_data alter column wheather type smallint;

Then you can change the default:

alter table device_data alter column wheather set default 10;

The column keyword is optional.

answered Dec 20, 2020 at 1:30

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1