The Vertica Database Forums

Posted: **Wed Mar 09, 2016 4:52 pm**

Hi

I have a table that is set to auto increment for the PK. Is there a command I can use so that I can get the generated auto increment key right after I insert?

Thanks!

Posted: **Wed Mar 09, 2016 9:06 pm**

Check out the LAST_INSERT_ID function!

https://my.vertica.com/docs/7.2.x/HTML/ ... ERT_ID.htm

Example:

Code: Select all

dbadmin=> create table earth (wind auto_increment, fire varchar(20));
CREATE TABLE
dbadmin=> insert into earth (fire) values ('Disco Lives!');
 OUTPUT
--------
      1
(1 row)

dbadmin=> select * from earth;
 wind |     fire
------+--------------
    1 | Disco Lives!
(1 row)

dbadmin=> select last_insert_id();
 last_insert_id
----------------
              1
(1 row)

The Vertica Database Forums

getting back id generated via autoincrement

getting back id generated via autoincrement

Re: getting back id generated via autoincrement