将Inno Setup exec函数中的命令传递到pgsql数据库

Question

我正在运行以下代码，试图从Inno安装脚本读取的文件中创建PostgreSQL数据库中的用户。不幸的是，执行的唯一命令是SET PGPPASSWORD和-U postgres elt命令，它们将我连接到数据库。我需要在数据库中运行的其他命令被忽略了，而且我似乎无法找到将它们输入数据库的方法。是否有字符可用于将命令输入到PostgreSQL数据库？

ExecAsOriginalUser('cmd.exe', '/k ' +'"SET PGPASSWORD=postgres&"' + 
    InstallPath+ '\psql -U postgres elt -c '+ 'CREATE USER ' 
    + Users[UserCount - 1] + ' WITH PASSWORD ' + '''' 
    + Password + '''' + '& ' + '\g', '', SW_SHOW, ewWaitUntilIdle, ResultCode);

命令行输出：

psql: warning: extra command-line argument "-c" ignored
"": extra command-line argument "CREATE" ignored
"": warning: extra command-line argument "USER" ignored
"": extra command-line argument "postgres" ignored
"": extra command-line argument "WITH" ignored
"": extra command-line argument "PASSWORD" ignored
"": extra command-line argument "'postgres'\g" ignorepsql 
(9.5.3) WARNING: Console code page (437) differs from    
Windows code page 
(1252) 8-bit characters might not work correctly. See psql reference page    
"Notes for Windows users" for details.
Type "help" for help.
db=#

Answer 1

您可能只需要将SQL包装为双引号：

ExecAsOriginalUser('cmd.exe',
    '/c SET PGPASSWORD=postgres& '
    + InstallPath + '\psql -U postgres elt -c "CREATE USER ' 
    + Users[UserCount - 1] + ' WITH PASSWORD ''' + Password + '''"',
    '', SW_SHOW, ewWaitUntilIdle, ResultCode);

首先，通过在命令行上运行以下命令来验证它：

cmd.exe /c SET PGPASSWORD=postgres& C:\eltfiles\pgsql\bin\psql -U postgres elt -c "CREATE USER postgres WITH PASSWORD 'postgres'"