postgreSQL INSERT data and RETURING values
If you are inserting data into a table with an auto increment column and if you want to get the value of the auto increment column.
Say you have a table called my_table:
If you want to insert data into my_table and get the id of that row:
Above query will return the id of the row where the new record was inserted.