pg_manage_comments
Manage PostgreSQL object comments by retrieving, setting, or removing comments on tables, columns, functions, and other database objects. Supports bulk discovery for efficient comment management.
Instructions
Manage PostgreSQL object comments - get, set, remove comments on tables, columns, functions, and other database objects. Examples: operation="get" with objectType="table", objectName="users", operation="set" with comment text, operation="bulk_get" for discovery
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columnName | No | Column name (required when objectType is "column") | |
| comment | No | Comment text (required for set operation) | |
| connectionString | No | PostgreSQL connection string (optional) | |
| filterObjectType | No | Filter by object type in bulk_get operation | |
| includeSystemObjects | No | Include system objects in bulk_get (defaults to false) | |
| objectName | No | Name of the object (required for get/set/remove) | |
| objectType | No | Type of database object (required for get/set/remove) | |
| operation | Yes | Operation: get (retrieve comments), set (add/update comment), remove (delete comment), bulk_get (discovery mode) | |
| schema | No | Schema name (defaults to public, required for most object types) |