Universal Postgres CRUD Utility
Budget: ₹1,500 – ₹12,500 INR
I need a reusable SQL/PL-pgSQL routine that can handle Create, Read and Update actions against any table in my PostgreSQL database. Table names, column sets and primary keys will be supplied at runtime, so the logic must build its statements dynamically while remaining fully safe against SQL-injection.
The procedure has to accept and correctly persist or retrieve every column type I might throw at it—numeric, text, date/time, JSON, arrays and any other standard Postgres datatype—without me having to hand-code separate cases.
Deliverables
• One well-commented function or set of functions packaged in a .sql file
• A short README showing call examples for each action (insert, select with filters, update) and explaining required parameters
• Proof it works through a couple of sample calls on dummy tables with mixed data types
I’m happy to clarify edge cases while you build, but the end goal is a single, future-proof CRUD utility I can drop into any project and trust immediately.
The procedure has to accept and correctly persist or retrieve every column type I might throw at it—numeric, text, date/time, JSON, arrays and any other standard Postgres datatype—without me having to hand-code separate cases.
Deliverables
• One well-commented function or set of functions packaged in a .sql file
• A short README showing call examples for each action (insert, select with filters, update) and explaining required parameters
• Proof it works through a couple of sample calls on dummy tables with mixed data types
I’m happy to clarify edge cases while you build, but the end goal is a single, future-proof CRUD utility I can drop into any project and trust immediately.