Top
Enterprise Postgres 17 Operation Guide

13.3.1 Removing the Extension

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.