Execute DROP EXTENSION to remove the high-speed data load extension. The extension needs to be removed on each database.
Example
The example below removes the extension on the "postgres" database.
postgres=# DROP EXTENSION pgx_loader; DROP EXTENSION
Note
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.
Only superusers can remove the high-speed data load extension.
The high-speed data load extension can only be removed on the public schema.