I do most of my DB work in PostgreSQL. I like it. It’s object oriented, has loads of functionality, high level of SQL compliance, is Open Source, etc. Unfortunately I have to work in Oracle for my JDBC course. I didn’t think that would be a big problem, I kind of thought that Pgsql is […]

The above is something that I realized only after a long time of experimenting with PostGreSQL. You see, when you want the default value of a column to be the next val of a sequence you need write:
nextval(’”seq_prodOrganizerPk”‘)
The single quotes seem to mean that it’s an relation somewhere in the schema (not a column in […]