I have a MySQL/PHP app that I want to port to PostgreSQL so I just installed the mysql_fdw from https://github.com/EnterpriseDB/mysql_fdw because I'd like to do the data migration in SQL if possible.
Installation and set up worked flawlessly but when I run the following query SELECT title, description, '[' || starts || ', ' || COALESCE(ends, 'infinity') || ']' FROM _filler WHERE starts IS NOT NULL AND description IS NOT NULL AND LENGTH(TRIM(title)) > 0 AND LENGTH(TRIM(description)) > 0;
I get the following error:
ERROR: failed to prepare the MySQL query: FUNCTION latest.btrim does not exist
FYI: Tables names that start w/ _ are the MySQL versions of PostgreSQL tables.
