CODEWITHSUNDEEP
mysqlsqlpostgresqlamazon-redshift
eistrati
eistrati

Reputation: 2354

Redshift Insert Multiple Rows

I'm struggling to insert multiple rows into Redshift. Here are the SQL queries:

CREATE TABLE tblA (
  column1 bigint primary key,
  column2 varchar(255) default null,
  column3 varchar(255) default null,
  recordModifiedTimestamp timestamp
);

INSERT INTO tblA (column1, column2, column3) VALUES
  (1, "DES", "article"),
  (2, "DES", "slideshow"),
  (3, "DES", "video");

When I run last query, here is what I get back:

ERROR:  column "des" does not exist in tblA

Am I missing something?

Upvotes: 0

Views: 7090

Answers (1)

eistrati
eistrati

Reputation: 2354

Well, thanks to Gordon Linoff, here is the correct SQL query:

INSERT INTO tblA (column1, column2, column3) VALUES
  (1, 'DES', 'article'),
  (2, 'DES', 'slideshow'),
  (3, 'DES', 'video');

Unbelievable! :-)

Upvotes: 5

Related Questions