PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
Many objects now support IF EXISTS clauses on ALTER statements, such as tables, foreign tables, indexes, sequences etc.