Generated value in Postgres

Asked May 07 '18 at 08:45

Active May 07 '18 at 09:01

Viewed 342 times

I'm new to postgres sql database. I'm developing a project in JAVA using postgres sql and hibernate. I cant' achieve the auto increment i.e Generated value like MySql and MSSQL server. How to implement that? Thanks in advance.

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID", unique = true, nullable = false)
public Integer id;

asked May 07 '18 at 08:45

Viji

Possible duplicate of [@GeneratedValue(strategy="IDENTITY") vs. @GeneratedValue(strategy="SEQUENCE")](https://stackoverflow.com/questions/8955074/generatedvaluestrategy-identity-vs-generatedvaluestrategy-sequence) – Ali Akbarpour May 07 '18 at 08:55
Add your create table statement. – May 07 '18 at 09:06
Are you defining the column as 'SERIAL' on the database creation script? – Nacho Soriano May 07 '18 at 09:44
I'm using hibernate. So I don't have _create table statement_. – Viji May 07 '18 at 10:00
I used the `@GeneratedValue(strategy = GenerationType.IDENTITY)`. But I didn't get the correct output. – Viji May 07 '18 at 10:02
You can try this: https://stackoverflow.com/questions/2011528/hibernate-auto-increment-id – Nacho Soriano May 07 '18 at 10:54

Generated value in Postgres

0 Answers0