PostgreSQL - change precision of numeric? <p>I tried to change precision like this:</p> <pre><code>ALTER Table account_invoice ALTER amount_total SET NUMERIC(5); </code></pre> <p>But I get syntax error, so I'm clearly doing something wrong. What is the right syntax to change precision of numeric in PostgreSQL?</p>