postgres table is not showing default values

Question

I'm stuck with a weird programming problem. I've defined a schema where if no values are passed for a column (column name is Title) then a default value (Harry) will be used.

Title | character varying(64) | default 'Harry'::character varying

And, I'm trying to insert entries using hibernate through my java application.

What's happening is that hibernate is explicitly giving null value to that column in any query and thus the default value is not showing up in the table for those entries.

Just like to mention here that when I execute any insert sql query myself without passing any value for that column then I'm able to see the default value in the corresponding row !

So any pointer on how to handle this hibernate-postgres case ??

stackoverflow.com/questions/14703697/… Could you check this one I think you will get some clarification. — Fahad Anjum
– Fahad Anjum, Commented Apr 29, 2017 at 3:59

gautam · Accepted Answer · 2017-04-29 03:55:35Z

1

Got it.... using the annotation:

@org.hibernate.annotations.Entity(
        dynamicInsert = true
)

answered Apr 29, 2017 at 3:55

gautam

1971 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres table is not showing default values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related