I'm trying to pass a script to create and insert data from a Firebird database to PostgreSQL, however in some tables syntax error is occurring, I'm using the SQL Manager Interbase & Firebird to generate the * .sql files from my Firebird database tables. I have already tried via CMD to send the files to the bank through the following command:
psql -h host -p 5432 -U postgres -d database -f (* .sql file location)
but the following error returns me:
psql:C:/Backup/Script/CONTROLEIMPRESSOES.sql:573: ERROR: column "DATA" is of type date but expression is of type integer
LINHA 6: (163, 6, 2007-02-01, 29138, 31432, 2294, 160.58, 31388, 33...)
DICA: You will need to rewrite or cast the expression
SoIwentthroughpgAdminandtheonlywaytoinsertitintothedatabasewastoputthedatebetween"2007-02-01"
.
My question is, how can I generate a * .sql file where the dates already come in parentheses, so I do not need to change row by row by adding ""
on each date.