Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Postgresqls native API uses numbers for types but SQL Relay mangles them. How do I get the numbers?

April 26, 2017API mangles native Numbers PostgreSQL Relay sql types uses

0

Posted

Postgresqls native API uses numbers for types but SQL Relay mangles them. How do I get the numbers?

1 Answer

0

Posted

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”.