PostgreSQL Update Error

Question

I am trying to update rows for a table using this query:

UPDATE point 
SET ftp_base = ftp://ftp.geonet.org.nz/strong/processed/Proc/2007/02_Final/2001-02-04_191426/Vol3/data/20070204_191426_KFHS.v3a
WHERE evt_id = '1121';

It is giving me the error "syntax error at or near SET".

user330315 · Accepted Answer · 2012-02-10 22:10:11Z

3

point is a reserved word (a datatype). You need to enclose this in double quotes:

UPDATE "point"
   SET ftp_base = 'your value goes here'
WHERE evt_id = 1121

Don't forget the single quotes around the character values, and do not put them around numbers.

answered Feb 10, 2012 at 22:10

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL Update Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related