A column type is part of the data contract. Use integer types for whole counts and numeric for exact decimal calculations. Floating point represents approximate measurements and can introduce rounding differences. Text keeps codes such as '0017' intact; a numeric conversion would discard their leading zeros.
Timestamps need a time-zone decision. TIMESTAMPTZ represents an instant and displays it in the session time zone. TIMESTAMP represents a local date and time without that conversion. A date has no time of day. Avoid guessing which one an imported string means.
PostgreSQL also supports arrays, UUIDs, ranges and JSONB. Choose them because they match a requirement. A JSONB value doesn't enforce the same shape as typed columns. Cast deliberately when extracting JSON text, and keep malformed source values visible before converting them.
Exact decimal arithmetic preserves the requested fractional values.