Hi, This patch improves the user experience when working with COPY commands by adding helpful error hints for invalid options.
Currently, when users make typos in COPY option names or values, they receive a generic error message without guidance on what went wrong. This patch adds two types of hints: 1. For invalid option names: suggests the closest matching valid option using the ClosestMatch algorithm (e.g., "foramt" → "Perhaps you meant 'format'") 2. For invalid option values: lists all valid values when the set is small (e.g., for format, on_error, log_verbosity options) This follows the pattern already used elsewhere in PostgreSQL for providing helpful error hints to users. Additionally, this patch corrects a misleading comment for the convert_selectively option. The comment stated it was "not-accessible-from-SQL", but actualy it has been accessible from SQL due to PostgreSQL's generic option parser. The updated comment clarifies that while technically accessible, it's intended for internal use and not recommended for end-user use due to potential data loss. Best regards,
0001-Add-error-hints-for-invalid-COPY-options.patch
Description: Binary data
