postgres return last id codeigniter

Question

I'm new with postgres database codeigniter

for return last id in mysql im using this in my model

public function daftar($data){
                $this->db->insert('akun', $data);
                return $this->db->insert_id();
            }

but I'm confuse how to return las id ($this->db->insert_id) in postgres?

name sequence for coloumn id_akun in table akun I forget to delete it — faza, Nov 30 '16 at 10:23
replace this `return $this->db->insert_id();` and add `echo $this->db->insert_id(); die;` — Abdulla Nilam, Nov 30 '16 at 10:27

score 4 · Answer 1 · answered Nov 30 '16 at 10:36

From the CodeIgniter documentation:

If using the PDO driver with PostgreSQL, or using the Interbase driver, this function requires a $name parameter, which specifies the appropriate sequence to check for the insert id.

In your case you need return $this->db->insert_id('akun_id_akun_seq'); if "akun_id_akun_seq" is the name of the respective sequence.

score 0 · Answer 2 · edited Oct 18 '18 at 13:04

0

If your INSERT is something like this:

INSERT INTO public."MyTable"
(
    "SomethingIdFk", 
    "Date"
) 
VALUES 
(
    8, 
    CURRENT_TIMESTAMP
);

And MyTable has a serial like MyTableId as primary key, then in your model you can do this:

$id= $this->db->insert_id('public."MyTable_MyTableId_seq"');

to get the last insert id.

That works for me.

More info you can find in this post.

edited Oct 18 '18 at 13:04

Suraj Rao

29,388
11
94
103

answered Oct 18 '18 at 12:33

jsanmarb

906
12
14

postgres return last id codeigniter

2 Answers2