Re: docs: psql and variable interpolation

po 13. 7. 2020 v 15:09 odesílatel Philippe Beaudoin <
philippe(dot)beaudoin(at)dalibo(dot)com> napsal:

> Hi all,
>
> I recently used the nice variable capabilities in psql, after having read
> the "SQL Interpolation" chapter in the psql page (
> https://www.postgresql.org/docs/12/app-psql.html).
>
> But I spent a lot of time trying to understand why using a variable in a
> \copy command failed ... until a colleague of mine showed me this was
> actually written elsewhere in the documentation (formerly in the \copy
> chapter).
>
> 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)."
>
+1

or maybe better - if it is possible reduce a exceptions

Pavel

> Regards. Philippe.
> ------------------------------
> <https://www.dalibo.com/>
> *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(dot)beaudoin(at)dalibo(dot)com
> Valorisez vos compétences PostgreSQL, certifiez-vous chez Dalibo
> <https://certification.dalibo.com/> !
>