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.
x
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;