Re: psql variables in the DO command

Pavel Luzanov <p.luzanov@xxxxxxxxxxxxxx> · Mon, 5 Mar 2018 16:52:32 +0300



    On 05.03.2018 16:42, Pavel Stehule wrote:

    
                I can't use psql variable in the DO command. Is it
                intentional behavior?

              
              yes. psql variables living on client side, and are
                not accessible from server side . DO command is executed
                on server side.

              
    But SELECT command also executed on a server side ))

    I thought that the command is sent to the server after variable's
    replacement.

    
              you can copy psql variables to GUC variables by
                set_config function, and then on server side use
                current_setting function for getting the content.

              
    Yes, I know about workarounds.

    
    -----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company