how to import data into postgresql?

[subaochen]

hi,

I'm trying to import some data into postgresql database, the entity like :

@Entity
@Table(name = "user", schema = "public")
public class User implements java.io.Serializable {

    private Integer id;
    private String username;
    private String password;

@Id
    @SequenceGenerator(name = "user_seq", sequenceName = "user_id_seq", allocationSize = 1)
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "user_seq")
    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    ......
}

And import.sql like :

insert into user(username,password) values('admin','admin');

The problem is, hibernate will automatically generate the id field of user table as type integer, not type serial, so import.sql will generate error:

Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint

So, how to let hibernate to generate the correct id field (serial type, not integer type)?

Thanks in advance!