Re: Example of RETURNING clause to get auto-generated keys from INSERT

On Tue, Jan 23, 2007 at 23:19:47 -0600,
Adam Rich <adam(dot)r(at)sbcglobal(dot)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.