AWS RDS Aurora PostgreSQL Serverless: boto3: RETURNING CLAUSE

0

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

pkered
질문됨 3년 전465회 조회
1개 답변
0

ok, I have misunderstood the docs.

the RETURNING clause will normally provide the returned data in "generatedFields". However, it does not work for Aurora PostgreSQL

  • Closed Question -

Derek

pkered
답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인