
Closed
Posted
Paid on delivery
I need a single, fully-parametric SQL solution that can handle Select, Update and Delete operations—as well as Insert—against any table in my PostgreSQL database. The goal is to pass in a table name, a dynamic list of column names, variable data types and the necessary filter or value clauses, then have the function build and execute the correct statement on the fly. Here is what I expect: • A PL/pgSQL function (or clear alternative, such as a prepared statement generator) that accepts: – target table – columns and their values or filters – operation flag (select / insert / update / delete) – optional returning clause for selects • Robust handling of variable data types so the same call works for integers, text, timestamps, JSON, etc. • Protection against SQL injection through proper use of format(), quote_ident() and parameter binding. • Comments or a short README showing sample calls for each operation and explaining required parameters. If the script installs cleanly and every sample call executes as expected, I’ll consider the job complete.
Project ID: 40509059
27 proposals
Remote project
Active 19 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
27 freelancers are bidding on average ₹6,911 INR for this job

I am database expert with16 year of experience and can work on the same to give you the exactresult. Lets discuss and will share you the code on the same daty
₹15,000 INR in 7 days
4.4
4.4

Hello, I can develop a secure, reusable PL/pgSQL solution that supports INSERT, SELECT, UPDATE, and DELETE operations through a single parameterized interface. The function will accept dynamic table names, columns, values, filters, and operation types while safely handling various PostgreSQL data types, including integers, text, timestamps, booleans, JSON/JSONB, and numeric values. The implementation will prioritize security by using PostgreSQL best practices such as format(), quote_ident(), and parameterized execution to minimize SQL injection risks. I will also provide clear examples for each operation, installation instructions, and sample test cases to verify the function works as expected. The final deliverable will be a clean, documented script that installs directly on PostgreSQL and is easy to extend for future requirements. Thank you.
₹2,499 INR in 7 days
3.9
3.9

As an experienced freelance database developer, I believe I am the ideal candidate to fulfill your need for a fully-parametric SQL solution for PostgreSQL. My expertise lies in developing robust, flexible and secure queries that ensure proper use of format(), quote_ident() and parameter binding, thereby eliminating any risk of SQL injection. One of my core strengths is my ability to work with various data types with ease and efficiency. I understand the gravity of your request to execute operations on not just integers and texts but also on more complex data forms. This won't be a challenge as I've worked extensively on similar projects, my team and I having over 10+ years of experience in handling all major development technologies. Lastly, what sets me apart is my constant commitment to delivering high-quality results at a cost-effective price point. My solutions are known for their clean codes and simple UI which ensures easy navigation for users of any skill level. Rest assured, if you entrust me with your project, you will receive a meticulously planned, executed and well-documented solution that both meets your needs perfectly and exceeds your expectations. I'd be happy to provide you samples if needed or demonstrate live how this query would work for any hypothetical scenario you have in mind.
₹3,000 INR in 2 days
1.4
1.4

As an experienced multi-skilled professional, I believe I am the right person to handle your PostgreSQL CRUD Query project. My background in full-stack development, with proficiency in SQL, is essential to building a dynamic and fully-parameterized solution that meets your exact needs. I have a deep understanding of PostgreSQL database handling including creating highly-optimized, safe SQL queries while ensuring proper handling of different data types to avoid SQL injections. In addition, my strong design, content creation and technical support skills complement these technical abilities. For instance, as per your requirement of adding comments and appendix explaining required parameters, my experience in content writing and documentation will be valuable in providing detailed yet concise documentation to accompany your project. Choosing me for your project not only ensures smooth installation and execution of the script but also a reliable long-term collaborator dedicated to delivering work that adds real value to your digital ecosystem. Let's connect and discuss how I can turn your PostgreSQL query requirements into a comprehensive solution.
₹7,000 INR in 7 days
0.0
0.0

Hi, I reviewed your requirements and understand the goal of building a secure, fully-parametric PostgreSQL CRUD solution that dynamically handles select, insert, update, and delete operations across any table. I have experience working with PostgreSQL, dynamic query generation, APIs, and structured backend logic. I can implement a clean, secure solution with proper SQL injection protection, support for variable data types, and clear usage examples/README. I’d be glad to work on this. Best regards, Alyosha
₹3,000 INR in 6 days
0.0
0.0

I can give you a single PL/pgSQL function that will run any SELECT, INSERT, UPDATE or DELETE on any table you pass, handling column lists, values, filters and returning clauses while keeping everything safe from injection. My approach will be to build a wrapper that receives the table name, an array of column‑name/ value JSON pairs, the operation flag and optional RETURNING fields. Using format() with quote_ident() for identifiers and EXECUTE … USING for the values will let us support integers, text, timestamps, JSON, etc., without manual casting. The function will return a SETOF RECORD for selects (or the requested RETURNING) and a simple status for DML actions. I’ll include a short README with sample calls for each operation and explain the expected JSON structure. We’ve built similar dynamic query generators for a logistics client’s reporting engine, and the code shipped cleanly and passed all edge‑case tests on the first run. I’ll also set up a quick test script you can run after installation to verify each sample. Could you confirm whether you prefer the column/value input as a JSON array or separate text/array parameters? Happy to fine‑tune that before I start. Best regards, Dinesh Kumar Design & Development Tech
₹7,000 INR in 7 days
0.0
0.0

Hi, I can do this. I’ve worked with PostgreSQL and dynamic PL/pgSQL functions before, so building a flexible CRUD function like this won’t be an issue. I’d create a single function that takes the table name, operation type, and data (likely in JSON format), then safely builds and runs the query using format() and proper identifier quoting to avoid SQL injection. It’ll support insert, update, select, and delete in one place, with optional returning where needed. I’ll also add a few simple examples so it’s easy to call for each case. If you want, I can keep it very minimal or make it more structured depending on how you plan to use it. Thanks
₹9,000 INR in 2 days
0.0
0.0

I can write it for you, It will accept table name, column name and filters in where condition based on this delete, update will be working even retrieval option also can be added, I can create these query quickly
₹8,000 INR in 7 days
0.0
0.0

Hi, there! In a recent project, I developed a dynamic PL/pgSQL function that facilitated CRUD operations on various tables within a PostgreSQL database, enhancing data manipulation flexibility. I designed the function to accept parameters for the target table, columns, values, and operation type, ensuring it could handle diverse data types like integers, text, timestamps, and JSON. A challenge I faced was ensuring robust protection against SQL injection, which I addressed by implementing parameter binding and using functions like format() and quote_ident() to sanitize inputs effectively. I offer to create a fully-parametric SQL solution that executes Select, Insert, Update, and Delete operations dynamically based on provided parameters. My unique approach includes comprehensive documentation with sample calls for each operation, ensuring clarity and ease of use for your development team. If I use my previous experience, your project will likely be completed successfully. Hope to discuss this in detail. Through detailed discussion, I think I can find the better solution to finish your project successfully. Thank you!
₹7,000 INR in 7 days
0.0
0.0

Hi As you have mentioned in the job descrption to work with the postgres operations We are ready to work and manage the database operations. Let's connect for more discussion. Thanks
₹7,000 INR in 7 days
0.0
0.0

Hello, The conversion script and solution are ready. You can review the sample implementation at your convenience. Once you provide access to your Git repository, I can integrate the remaining components, share the complete solution, and provide a detailed demo. I will also explain each component and include appropriate README documentation covering setup, usage, and deployment instructions.
₹7,000 INR in 7 days
0.0
0.0

"Hello, I am a Database Specialist with advanced knowledge in relational databases and SQL scripting. I can perfectly build your universal PostgreSQL CRUD solution using dynamic SQL to handle Select, Insert, Update, and Delete operations for any table name, columns, and variables safely. I strictly follow performance and security guidelines. Let's discuss your project requirements."
₹7,000 INR in 7 days
0.0
0.0

Hi! I can build this universal PL/pgSQL CRUD function for you. It will handle SELECT, INSERT, UPDATE, DELETE with full SQL injection protection using format() and quote_ident(). I'll include a README with sample calls for each operation. Ready to deliver quickly. Budget: ₹2,500
₹2,500 INR in 7 days
0.0
0.0

Hi, I can build this as a clean PostgreSQL/PLpgSQL utility with safe dynamic SQL. I would deliver: - an installable SQL file with the CRUD function or small helper function set - safe identifier handling with quote_ident/format and parameterized values where appropriate - support for select, insert, update, and delete through an operation flag - sample calls for each operation using different data types - comments plus a short README explaining required parameters and limits I would avoid unsafe string concatenation and keep the interface practical, likely using JSONB/structured parameters for values and filters so it stays flexible across tables. My bid is INR 7,000 and I can deliver the tested first version in 1 day.
₹7,000 INR in 1 day
0.0
0.0

Hi, I'm an experienced DBA with hands-on PostgreSQL development and administration expertise. I can build a secure, fully dynamic PL/pgSQL CRUD solution supporting SELECT, INSERT, UPDATE, and DELETE across any table with proper parameterization, datatype handling (JSON, timestamps, integers, text, etc.), SQL injection protection, and clear documentation with sample calls. My focus is on clean, reusable, production-ready code that is easy to maintain and extend.
₹3,000 INR in 7 days
0.1
0.1

With over the years of experience working with complex database systems, I'm well-equipped to provide an elegant solution for your Universal PostgreSQL CRUD Query project. MySQL and Rust, C++ and Python development are among my skillset, which makes handling a relational database system like PostgreSQL second nature to me. Given my extensive knowledge in database administration and management, I possess a sound understanding of query languages such as SQL. My experience in designing, optimizing, indexing and securing advanced database schemas further cements my suitability for this project. Additionally, I'm adept at creating clean, modular codebases that adhere to strict project lifecycles—a guarantee you can depend on for your Universal PostgreSQL CRUD Query. Moreover, as a qualified Systems Engineer, one of my specialities is constructing memory-safe backend systems—a crucial trait when dealing with data-intensive operations like the one your project necessitates. I am deeply committed to producing high-performance solutions, built to PL/pgSQL function or appropriate substitute that confidently handles
₹1,500 INR in 7 days
0.0
0.0

Hello, I have reviewed your requirement for a fully dynamic PostgreSQL PL/pgSQL solution that supports SELECT, INSERT, UPDATE, and DELETE operations across any table with safe handling of parameters and data types. I am an IT Consultant with strong experience in SQL, database logic, and enterprise backend systems. I have worked extensively with structured data environments in production systems, focusing on query optimization, data handling, and troubleshooting complex database-related issues. I can build a secure and reusable PL/pgSQL function that: Dynamically handles CRUD operations using safe SQL practices Supports multiple data types including text, integer, timestamps, and JSON Uses format(), quote_ident(), and parameter binding for SQL injection protection Includes clear sample calls for each operation Comes with a short README for easy usage and maintenance I will ensure the solution is clean, maintainable, and ready for production use. Looking forward to working on this.
₹7,000 INR in 4 days
0.0
0.0

I work with PostgreSQL daily and this is a clean, well-scoped task. I'll deliver a single `crud_execute()` PL/pgSQL function that accepts table name, column array, value array, operation flag, and an optional filter clause. It'll use `format()` + `quote_ident()` for identifiers and parameterised `EXECUTE ... USING` for all values — no raw concatenation, fully injection-safe across int, text, timestamp, JSONB, and other types. Ships with a short README showing a working sample call for each of the four operations (SELECT, INSERT, UPDATE, DELETE), plus a test script you can run straight away to verify every case passes. Ready to start immediately, delivery in 2 days.
₹12,000 INR in 2 days
0.0
0.0

Building one function that can safely handle Select, Insert, Update, and Delete for any table is the kind of thing that looks straightforward at first, but gets tricky fast once you factor in data types, dynamic filters, and security. I’ve worked a lot with PostgreSQL and dynamic SQL, so this is something I’m comfortable building. I can put together a flexible PL/pgSQL function that takes the table name, columns, values, and operation type, and builds the correct query while keeping it safe from SQL injection. I’ll also make sure it’s easy to understand and actually usable—not just “working.” That means clean structure, comments, and sample calls for each operation so you can test and extend it easily. If the goal is to have one reliable function you can reuse across your database without headaches, I’d be happy to build it.
₹8,000 INR in 7 days
0.0
0.0

I have 10 yrs experience in database development. This task requires dynamic sql with proper parameters for select/ insert/ update/ delete.
₹9,000 INR in 2 days
0.0
0.0

Coimbatore, India
Member since Mar 4, 2026
₹1500-12500 INR
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
$8-15 USD / hour
₹12500-37500 INR
₹37500-75000 INR
$750-1500 USD
₹37500-75000 INR
min $50 USD / hour
₹75000-150000 INR
$250-750 USD
₹400-750 INR / hour
$3000-5000 USD
$8-15 USD / hour
$250-750 USD
₹100-400 INR / hour
₹750-1250 INR / hour
$10-30 USD
$250-750 USD
$250-750 USD
$250-750 AUD
$250-750 USD
₹37500-75000 INR