2.5 Dropping a Package

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

2 Packages : 2.5 Dropping a Package

2.5 Dropping a Package

The syntax for deleting an entire package or just the package body is as follows:

DROP PACKAGE [ BODY ] package_name;

If the keyword, BODY, is omitted, both the package specification and the package body are deleted - i.e., the entire package is dropped. If the keyword, BODY, is specified, then only the package body is dropped. The package specification remains intact. package_name is the identifier of the package to be dropped.

Following statement will destroy only the package body of emp_admin:

DROP PACKAGE BODY emp_admin;

The following statement will drop the entire emp_admin package:

DROP PACKAGE emp_admin;

2 Packages : 2.5 Dropping a Package