Hi,
This question is in reference to:
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds-data.html
<note> <p>The <code>generatedFields</code> data isn't supported by Aurora PostgreSQL. To get the values of generated fields, use the <code>RETURNING</code> clause. For more information, see <a href="https://www.postgresql.org/docs/10/dml-returning.html">Returning Data From Modified Rows</a> in the PostgreSQL documentation.</p> </note>
Kindly advice on how I can get the id of a newly inserted row
sql used:
INSERT INTO {0}({1})
VALUES ({2})
RETURNING id;
As mentioned in the docs, response does not contain "generatedFields".
Thank you
Derek