Altering Character Varying Column Length in PostgreSQL

How to Delete Big Table Rows while Preserving Auto-Incrementing Primary Key in Oracle