I need to migrate a database from Firebird 1.5 to PostgreSQL (version 8.4, that's the version installed in the server of my customer. It's not under my control so I can't update).
I used the trial version of the EasyFrom program, and it worked for the tables, but it seems that the triggers were not migrated (I used the select * from pg_trigger command and the triggers I wanted to migrate were not shown; also in pgAdmin, in Schemas > Public > Tables > specific_table > Trigger there's nothing)
Is there a program or a simple way to migrate the triggers? Or do I need to manually create the trigger migration?
Short answer: no.
Long answer: every database has their own dialect for triggers, and their own quirks you need to take into account. Although it could be possible to translate this automatically, there are - as far as I am aware - no tools that do this for you.
In other words: you will need to do this yourself.