Execute DROP EXTENSION to remove the high-speed data load extension. The information required for operation of high-speed data load is stored in the pgx_loader_state table of the pgx_loader schema. Do not remove the high-speed data load extension if the pgx_loader_state table is not empty.
The extension needs to be removed on each database. Also, extensions can only be removed on the public schema by a superuser.
Example
The example below removes the extension on the "postgres" database.
postgres=# DROP EXTENSION pgx_loader; DROP EXTENSION
