Changing data type from numeric to integer?

Question

PostgreSQL

How can PostgreSQL cast data types from a single data type, such as numeric to integer?
Those. there are tables and with one sql query we write a command to transfer the data type of two fields from one to another.
So how to execute dynamic ddl in anonymous block using pgAdmin?

Answer 1

Do you understand the question? Anonymous block? What it is ?
Change the type of an existing column

ALTER TABLE articles
    ALTER COLUMN manufacturer TYPE integer -> На какой тип меняем
    USING manufacturer::integer; -> Преобразовываем значения