sql - How do I create row numbers in Redshift? -

sql - How do I create row numbers in Redshift? -

i create table using select statement , add together column row numbers

so i'd write like:

create table schema.table_w_rownumbers select identity(1, 1) nrum, foo.* schema.initial_table foo;

try code. create sure alter order id whatever needs ordered by.

create table schema.table_w_rownumbers ( select row_number() on (order id) nrum, * schema.initial_table );

sql postgresql amazon-redshift