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

[Bruno Wolff III <bruno@xxxxxxxx>]

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