GOAL
- I would like to add a Redshift SUPER column to and existing redshift table.
- I need this to store JSON data there
CODE
This is how Normally I would add a new column.
ALTER TABLE products ADD COLUMN created_at NOT NULL;
1. Tried
CREATE TABLE temp_test_persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); ALTER TABLE temp_test_persons ADD COLUMN newSuperColumn SUPER NOT NULL;
Error running query: ALTER TABLE ADD COLUMN defined as NOT NULL must have a non-null default expression
Reviewed Solutions
- Alter column data type in Amazon Redshift
- AWS Redshift – Add IDENTITY column to existing table
- Adding column to existing tables
- Add dynamic column to existing MySQL table?
- SQLAlchemy: How to add column to existing table?
- adding columns to an existing table
- add column to existing table postgres
- How to add not null unique column to existing table
- Adding columns to existing csv file using super-csv
- UCanAccess: Add column to existing table
- Adding columns to existing redshift table
- How to add column to existing table in laravel?
- Add column to existing table in rds
- oracle add column to existing table
Advertisement
Answer
ALTER TABLE temp_test_persons ADD COLUMN newSuperColumn SUPER;