↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 6.3
Historical version. PostgreSQL 6.3 has reached end of support. See the current manual.
PostgreSQL
PrevChapter 13. The Query LanguageNext

Updates

You can update existing instances using the update command. Suppose you discover the temperature readings are all off by 2 degrees as of Nov 28, you may update the data as follow:

UPDATE weather
    SET temp_hi = temp_hi - 2,  temp_lo = temp_lo - 2
    WHERE date > '11/28/1994';


PrevHomeNext
Joins Between ClassesUpDeletions

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.