How to change a PG column to NULLABLE TRUE?
How can I accomplish this using Postgres? I've tried the code below but it doesn't work:
ALTER TABLE mytable ALTER COLUMN mycolumn BIGINT NULL;
m
mu is too short
From the fine manual:
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;
There's no need to specify the type when you're just changing the nullability.
The inverse is here: stackoverflow.com/questions/16197236/…
@ChristiaanWesterbeek mind-reader ?
Follow WeChat
Success story sharing
Want to stay one step ahead of the latest teleworks?
Subscribe Now相似问题
- Add a column with a default value to an existing table in SQL Server
- Can I concatenate multiple MySQL rows into one field?
- How do I escape a single quote in SQL Server?
- How do I UPDATE from a SELECT in SQL Server?
- How to do an update + join in PostgreSQL?
- How to change PostgreSQL user password?
- Rename column SQL Server 2008
- How do I import an SQL file using the command line in MySQL?
