et
Postgres do the rest for you. Obviously if you need to have a separate table B
ID, you can alter as necessary.
Good luck,
Richard Dunks
On Jun 10, 2013, at 7:29 PM, Aleksandr Furmanov
wrote:
> Hello,
> I want to insert new values into target table 'a' from source table &
I am doing wrong?
In your UPDATE statement, I'd suggest explicitly putting the "T" table alias
before each column you're setting. That will make the assignment more explicit
and hopefully get around the error.
>
> Also, is there an easier way to do that?
>
> Thanks for the help.
Best,
Richard Dunks
