In Progress

Write some Software

Hi,

I need a trigger function created in plpgsql that performs the following:

On CREATE TABLE event, create a view for that table that returns all columns in snake_case as camelCase.

Example

For a table with the following columns: _id, first_name, last_name, email...

A view should be created that performs the following query:

SELECT _id, first_name AS firstName, last_name AS lastName, email FROM table_name;

Skills: PostgreSQL, SQL

See more: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

Project ID: #12183044

Awarded to:

phiona06

Hi! I'm senior lecturer on databases with 10+ years experirnce in PostgreSQL. I propose use something like this command CREATE EVENT TRIGGER event_trg ON DDL_COMMAND_START WHEN tag IN ('CREATE TABLE') if obje More

£20 GBP in 0 days
(10 Reviews)
3.6

7 freelancers are bidding on average £28 for this job

truongnguyen86

Hello there, i'm expert on database programming, let me help you with this. Waiting for your feedback if interested. Thank you!! P.S: i can start right now and done in a couple of hours next...

£45 GBP in 1 day
(110 Reviews)
6.1
A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here http://www.a2design.biz/portfolio_ Here’s a little video about our team too! ht More

£24 GBP in 1 day
(2 Reviews)
5.8
vw7590795vw

Please review my profile. I have 7 years experience in SQL. Please let me know when will we start. Skype: jikenjd

£20 GBP in 1 day
(8 Reviews)
3.0
Programmer59

Hello Sir....! I read your description I can do that also I will complete your project on time and within your budget I am fully confident about your project. I will receive your best wishes. I am waiting your respo More

£28 GBP in 1 day
(2 Reviews)
2.2
shivakalwa

i am a software engineer...searching for a part-time job for extra money.i am a pl/sql developer working in a private company and searching for a extra money for my family...so plz give me project

£18 GBP in 1 day
(0 Reviews)
0.0
£38 GBP in 1 day
(0 Reviews)
0.0