插入具有不同列名的mysql和postgresql

Question

I ported my application from mysql to postgresql. In doing so camel cased column names where changed to use an underscore as the word separator in most cases. There are a couple where the camel case was just removed.

I now need to insert to both of these databases. The data, the number of columns etc are the same just the column names are slightly different. I can use PDO to switch database drivers and insert, but id like to do this without writing two seperate sql statements for inserts. Is there a common way to map column names to array keys or populate some class and pass that to PDO.

Answer 1

$column_names[] = array('someName'=>'some_name');
$column_names[] = array('someOtherName'=>'some_other_name');
$column_names[] = array('someOtherNameAgain'=>'some_other_name_again');

foreach($column_names as $mysql=>$post_ogre)
{
   //decide which one you want to use here
}

something similar to this should work