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?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 patch we could make to ecpg to accept input parameters?
