Auth library for PostgreSQL database

[eluser]matt.asbury[/eluser]
Depending on how many of these queries you would need to amend, I don't think it would be too difficult for you to understand the logic. I would recode them using codeigniter's database forge class (http://ellislab.com/codeigniter/user-gui...forge.html). In this example the logical entry would be:

Code:

$this->load->dbforge();
$this->dbforge->add_field('id'); //automatically create an int[9] auto increment primary key field
$this->dbforge->add_field('name varchar(50) NULL');
$this->dbforge->create_table('aurole');

This will give you code that will be portable between any CI supported database.