Re: Example of RETURNING clause to get auto-generated keys from INSERT - Mailing list pgsql-general

On Tue, Jan 23, 2007 at 23:19:47 -0600,
  Adam Rich <adam.r@sbcglobal.net> wrote:
>
> And your normal query would be this:
>
> INSERT into mytable (id,value) values (1,"foo"),(2,"bar");
>
> Your new query would be like this:
>
> INSERT into mytable (id,value) values (1,"foo"),(2,"bar")
> RETURNING id;

Note that you will want to be using single quotes not double quotes.