Postgres Pro
Downloads
Home   >   mailing lists

ecpg rejects input parameters - Mailing list pgsql-general

From Andrew Pennebaker
Subject ecpg rejects input parameters
Date
Msg-id CAHXt_SV=FaYpTr+scFFROo6MePOqFg0wrj6=5Vv_mVy7Ged74Q@mail.gmail.com
Whole thread Raw
Responses Re: ecpg rejects input parameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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?

--
Cheers,

Andrew Pennebaker

pgsql-general by date:

Previous
From: Björn Lundin
Date:
Subject: Re: unexpected (to me) sorting order
Next
From: Adrian Klaver
Date:
Subject: Re: ecpg rejects input parameters