Verified User in Electrical/Electronic Manufacturing
This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture.
"Good for the price, if you know what I mean"
What do you like best about PostgreSQL?
It's easy to use, it solves the issue and lets you do most of your work.
My favorite is definitely the foreign data wrapers, which provides a standardized way to access and manipulate data stored externally to the Postgres server you’re connecting to. Review collected by and hosted on G2.com.
What do you dislike about PostgreSQL?
A few of my complains:
I dont like that it doesn't let you edit queries when you try to edit a quick select that the tool auto generated.
The MONEY type is horrible. Run away. Use NUMERIC.
To write procedural code you need a DO LANGUAGE plpgsql $$ BEGIN ...code here ... END; $$; block. You can't write it inline like you can PL/SQL or T-SQL. (On the other hand, it helps reduce the amount of DBMS-specific SQL extensions and procedural code sneaking into the application's queries).
Don't use more than 1000-ish columns. There's a hard limit somewhere around 1400, depending on data type, but usually lower.You cannot remove typenames from an enum data type. Though you can add new ones. Review collected by and hosted on G2.com.
At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review.
Validated through a business email account
This reviewer was offered a nominal gift card as thank you for completing this review.
Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review.