PostgreSQL dump file restore problem

[kingstdio]

ISSUE

When I use the provided SQL script and dump file to reconstruct the database using PostgreSQL, I encountered an error while importing the compound_origins table: "UndefinedColumn: column 'component_accession' of relation 'compound_origins' does not exist."

CAUSE

The field component_accession in the compound_origins.sql file and pgsql_create_tables.sql file do not match due to a spelling error.

Please help to resolve this problem.

Thanks.