Home > mailing lists

PGSQL returning into in insert statement - Mailing list pgsql-novice

From	Chamath Sajeewa
Subject	PGSQL returning into in insert statement
Date	July 30, 2020 05:46:00
Msg-id	CACpofegcG+Ke2r4yoCpwRKPnV8r+fiGfB1w=ur4M3KHvTFKkpg@mail.gmail.com Whole thread Raw
Responses	Re: PGSQL returning into in insert statement (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

Hi all,

I want to use "returning into" in insert statement. I tried below,

insert into test_table(key,value) values('key1',5) returning value into returnvalue;

and below error occurred- syntax error at or near "into".

What is the correct method to use it?

Thanks!

From: "David G. Johnston"
Date: 30 July 2020, 05:32:53
Subject: Re: PGSQL insert data to a oid column using SOCI

From: Tom Lane
Date: 30 July 2020, 06:05:39
Subject: Re: PGSQL returning into in insert statement