PostgreSQL – Create view with autoincremental column


I have a PostgreSQL table, and I need to create a view with a new column. This column needs to be an auto-incremental column starting at 1 and going to N.

Is this possible to do without effecting the original schema of the legacy data structure?

Best Answer

As @deszo said user OVER()

create view foo as (
    select row_number() over (order by field), field, field2, field3 from bar