po 13. 7. 2020 v 15:09 odesílatel Philippe Beaudoin < philippe.beaud...@dalibo.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.beaud...@dalibo.com > Valorisez vos compétences PostgreSQL, certifiez-vous chez Dalibo > <https://certification.dalibo.com/> ! >
