Re: ecpg rejects input parameters

Could you be more specific?

I can't find a relevant section to address my specific problem: ecpg
complaining when I try to check the syntax of my .sql files that use input
parameters.

On Wed, Apr 8, 2015 at 9:34 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 04/08/2015 07:22 AM, Andrew Pennebaker wrote:
>
>> PostgreSQL uses a :colon syntax for parameterizing SQL commands with
>> command line variables.
>>
>> create-database.sql:
>>
>> CREATE DATABASE :db;
>>
>> Usage:
>>
>> $ psql -f create-database.sql -v db=test
>>
>> However, pgsanity/ecpg rejects these.
>>
>> $ pgsanity create-database.sql
>> line 1: ERROR: syntax error at or near ":db"
>>
>> Is there a flag I can give to ecpg to ignore input parameters?
>>
>> Is there a patch we could make to ecpg to accept input parameters?
>>
>> Is there another way to write my input parameters to work around this
>> error?
>>
>
> If I am following correctly:
>
> http://www.postgresql.org/docs/9.4/interactive/ecpg-variables.html
>
>
>> --
>> Cheers,
>>
>> Andrew Pennebaker
>> www.yellosoft.us <http://www.yellosoft.us>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Cheers,

Andrew Pennebaker
www.yellosoft.us