Re: update table from a csv file

On Dec 27, 2012, at 10:39 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> 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=#