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.kla...@aklaver.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.kla...@aklaver.com > -- Cheers, Andrew Pennebaker www.yellosoft.us
