You are able to update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by two levels right after November 28. It is possible to correct the info as follows: Observe that column aliases are necessary if not PostgreSQL will complain concerning the ambiguity https://pgupdate-in34532.blogminds.com/how-much-you-need-to-expect-you-ll-pay-for-a-good-pgupdate-in-36942968