The naming strategy Escape does not work for postgresql.

[halvorgb]

Without Escape:

LOG:  execute 1/1: INSERT INTO _pingdom (ip) VALUES ($1)
DETAIL:  parameters: $1 = '0:0:0:0:0:0:0:1'

With Escape:

ERROR:  column "$1" does not exist at character 39
STATEMENT:  INSERT INTO "_pingdom" ("ip") VALUES ("$1")

The problem is that $1 is escaped, but on postgres-9.5.1-1 thaẗ́'s invalid.

I looked through the source to fix the bug, but I can't seem to find something that links the io.getquill.sources.sql.idiom.SqlIdom trait to the io.getquill.naming.NamingStrategy trait.

[godenji]

Need to implement an escape strategy for Postgres.

Try something like the following in NamingStrategy source:

trait PostgresEscape extends Escape {
  override def column(s: String) = if(s.startsWith("$")) s else default(s)
}
object PostgresEscape extends PostgresEscape

Give it a shot and issue PR (along with corresponding test in NamingStrategySpec, see mysql example)

[fwbrasil]

@halvorgb The 0.4.1-SNAPSHOT version has a new naming strategy specific for postgres escaping[0]. Please let us know if you have problems using it.

[0] https://github.com/getquill/quill/blob/master/quill-core/src/main/scala/io/getquill/naming/NamingStrategy.scala#L83