What's the deal wih TEXT & VARCHAR, or NUMERIC, REAL, DECIMAL & INT ?
From postgresql.org:
- The only difference between TEXT and VARCHAR(n) is that you can limit the maximum length of a VARCHAR column
- NUMERIC & DECIMAL are the same in Postgres:
- numeric or numeric(p,s) is a real number with p precision digits & s scale number after the decimal point
- for DECIMAL the implementation is allowed to allow more digits than requested to the left of the decimal point. Postgres doesn't exercise that freedom so there's no difference between these types for us.
- REAL or float8 is a 4-byte floating-point number
All numeric types can be found here
The postgresql dump with pg_dump -cC --inserts -U freecodecamp universe > universe.sql always does sequential INSERT instead of inserting all rows at once. Why?
Since PostgreSQL 12 you can use pg_dump with --rows-per-insert=nrows