How do I change column default value in PostgreSQL?

Question

I've tried:

ALTER TABLE ONLY users ALTER COLUMN lang DEFAULT 'en_GB';

But it gave me an error:

ERROR: syntax error at or near "DEFAULT"

Silver Light · Accepted Answer · 2011-01-20 09:28:05Z

419

'SET' is forgotten

ALTER TABLE ONLY users ALTER COLUMN lang SET DEFAULT 'en_GB';

answered Jan 20, 2011 at 9:28

Silver Light

46.3k36 gold badges126 silver badges165 bronze badges

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

2 Comments

Nik Sumeiko Over a year ago

What for ONLY is used before the name of the table?

Yodan Tauber Over a year ago

"If ONLY is specified before the table name, only that table is altered. If ONLY is not specified, the table and all its descendant tables (if any) are altered" postgresql.org/docs/9.3/static/sql-altertable.html

RYS · Accepted Answer · 2018-03-23 02:45:02Z

132

If you want to remove the default value constraint, you can do:

ALTER TABLE <table> ALTER COLUMN <column> DROP DEFAULT;

edited Mar 23, 2018 at 2:45

RYS

4726 silver badges22 bronze badges

answered Dec 15, 2015 at 23:25

Salvador Dali

224k151 gold badges726 silver badges766 bronze badges

Collectives™ on Stack Overflow

How do I change column default value in PostgreSQL?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related