Re: docs: psql and variable interpolation

On Monday, July 13, 2020, Philippe Beaudoin <philippe.beaudoin@dalibo.com> wrote:

The first sentence of this SQL interpolation chapter says "A key feature of psql variables is that you can substitute (“interpolate”) them into regular SQL statements, as well as the arguments of meta-commands." But nothing in this chapter indicates that there are exceptions.

May be we could have a wording adjustment with something like : "A key feature of psql variables is that you can substitute (“interpolate”) them into regular SQL statements, as well as the arguments of meta-commands (unless specifically noted)."

Having “unless otherwise noted” be implied doesn’t seem like a big failing.  As for this case it is documented as being an exception:

“Unlike most other meta-commands, the entire remainder of the line is always taken to be the arguments of \copy, and neither variable interpolation nor backquote expansion are performed in the arguments.”

If it is only \copy that is an exception I’d rather just say (except \copy} and not have the user meticulously read each item for the single exception.  This extends to if there are a few.

As far as I know, the \! metacommand is another exception. But I don't know if there are some others.

David J.

---

	DALIBO L'expertise PostgreSQL 43, rue du Faubourg Montmartre 75009 Paris	Philippe Beaudoin Consultant Avant-Vente +33 (0)1 84 72 76 11 +33 (0)7 69 14 67 21 philippe.beaudoin@dalibo.com
Valorisez vos compétences PostgreSQL, certifiez-vous chez Dalibo !