Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Insert Data Rows into a Table

After you create a table, you can insert rows of data into that table.


The INSERT command inserts individual rows into a database table. For standard bulk loads, use the COPY command. For more information, see Use a COPY Command to Load Data.

For example, to insert a value of 100 into the testtable table (which contains a single column), issue the following command:

insert into testtable values (100);