What is best way to call postgresql function from codeigniter?

@scotty_walker 

The best way to call a PostgreSQL function from CodeIgniter is to use the CodeIgniter's built-in database library. You can create a custom model in CodeIgniter to interact with the PostgreSQL database and call the function within the model.

Here is an example of how you can call a PostgreSQL function from CodeIgniter using a custom model:

1
2
3
4
5
6
7
8
9

class Custom_model extends CI_Model {

    public function call_postgresql_function() {
        $query = "SELECT your_function_name() as result";
        $result = $this->db->query($query)->result_array();
        
        return $result;
    }
}

In this example, your_function_name() is the name of the PostgreSQL function that you want to call. You can replace it with the actual name of your function.

You can then load and use your custom model in your controller to call the PostgreSQL function:

1
2
3
4

$this->load->model('Custom_model');
$result = $this->Custom_model->call_postgresql_function();

// Do something with the result

Make sure that you have configured your database connection settings in the database.php file located in the application/config directory of your CodeIgniter application.

By following this approach, you can easily call PostgreSQL functions from CodeIgniter and retrieve the results within your application.