Rename column only if exists

Please read this article on codingvila.com for a detailed explanation.

Rename Column Only If Exists in PostgreSQL

DO $$
BEGIN
  IF EXISTS(SELECT *
    FROM information_schema.columns
    WHERE table_name="your_table" and column_name="your_column")
  THEN
      ALTER TABLE "public"."your_table" RENAME COLUMN "your_column" TO "your_new_column";
  END IF;
END $$;