PostgreSQL Auto Increment

gistfile1.sql

CREATE SEQUENCE mgr_id_seq;

CREATE SEQUENCE;

CREATE TABLE managers(  
  mgr_id INTEGER PRIMARY KEY DEFAULT NEXTVAL('mgr_id_seq'),  
  mgr_name VARCHAR(50),  
  mgr_email VARCHAR(50)  
);