Remove double quotes in codeigniter query Builder

Question

I am using the Codeigniter framework and every time I create a select with their Builder query, it puts double quotes on all columns and tables.

Ex: SELECT "ID", "NAME" FROM "STUDENT"

This ends up giving me problem, because I use 2 connections with database, oracle and pgsql. oracle works normally, already in pgsql returns me error.

I know that if I put the last parameter in my functions as false, it works, but I wonder if there is some global parameter to do this, or I’ll have to pass method by method the false ?

Answer 1

Use this line before your query (documentation here):

$this->db->_protect_identifiers = false;

For a global parameter in the file ./application/config/database.php (database configuration file), add a new element to the array of standard settings:

$db['default']['_protect_identifiers'] = false;

Answer 2

Codeigniter has a second parameter in the Builder query to prevent word escape, see this link with the documentation, but in short you can use something like this:

$this->db->select('campo', false)