Re: update table from a csv file

[Kirk Wythers <kirk.wythers@xxxxxxxxx>]

On Dec 27, 2012, at 10:39 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:

No. Some questions though.

Thanks for the reply Adrian. 

What version pf Postgres?

9.1

Is that the actual UPDATE statement, I see no SET?

I was reading the docs but obviously don't understand the syntax of the update statement. 

Have you tried it?
If so and it failed what was the error?

Yes and I got an error at or near from. Like this:

b4warmed3=# UPDATE sixty_min FROM tmp_60 WHERE sixty_min.rowid = tmp_60.rowid;

ERROR:  syntax error at or near "FROM"

LINE 1: UPDATE sixty_min FROM tmp_60 WHERE sixty_min.rowid = tmp_60....

                         ^

b4warmed3=#