Postgresqls native API uses numbers for types but SQL Relay mangles them. How do I get the numbers?
Prior to version 0.28, SQL Relay mangled Postgresql numeric types into pseudo-standard datatype names. I read a thread in a discussion group indicating that someone was specifically unhappy with SQL Relay because of this behavior though, and decided to change it. So, as of version 0.28, by default, SQL Relay returns numeric types when run against Postgresql. If you prefer getting type names, you can set the mangletypes connect string value to “yes” in your sqlrelay.conf file. For example, in version 0.28 or higher the following connectstring will instruct SQL Relay to return type names instead of numbers: user=myuser;password=mypass;db=testdb;mangletypes=yes In version 0.28 or higher the following connectstring will instruct SQL Relay to return type numbers: user=myuser;password=mypass;db=testdb;mangletypes=no Leaving the mangletypes parameter out altogether is the same as setting it to “no”.