I am trying to port a database where there is a table with a column of type
unknown. pg_restore raised the error
pg_restore: [archiver (db)] could not execute query: ERROR: column "color" has pseudo-type unknown`.
I don't understand why such tables can exist given that the doc says
A pseudo-type cannot be used as a column data type
However, I want to keep the database as it is and do not do any modifications. Which error code should I specify to catch this exception?