Ispirer Migration Knowledge Base sqlways:postgresql:techniques https://wiki.ispirer.com/ 2026-06-22T01:46:17+00:00 Ispirer Migration Knowledge Base https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) PostgreSQL - BULK COLLECT conversion to PostgreSQL https://wiki.ispirer.com/sqlways/postgresql/techniques/bulk-collect?rev=1741078744&do=diff User Documentation Ispirer Capabilities - MySQL Migration Pricing PostgreSQL - BULK COLLECT conversion to PostgreSQL A bulk collect is a method of fetching data when many rows are placed in a collection at once. This can be a problem when migrating procedures from databases that support this mechanism to others that do not. In this case, Oracle supports the bulk collection, but PostgreSQL does not. The Ispirer toolkit allows you to solve this problem and convert procedures that contain BULK CO…