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.
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.klaver@xxxxxxxxxxx> wrote:
If I am following correctly: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?
http://www.postgresql.org/docs/9.4/interactive/ecpg-variables.html
--
Cheers,
Andrew Pennebaker
www.yellosoft.us <http://www.yellosoft.us>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
