This is interesting to me, too. I do not see any options anywhere to force the type. However looking at the code it does appear that it handles integers and treats everything else as a string. See this full example:
[[outputs.file]] ## Files to write to, "stdout" is a specially handled file. files = ["stdout"] [[inputs.postgresql_extensible]] address = "host=yertle user=vivek sslmode=disable dbname=postgres" [[inputs.postgresql_extensible.query]] sqlquery="select 10.0 as myvalue" version=901 withdbname=false tagvalue="" measurement="something" [[inputs.postgresql_extensible.query]] sqlquery="select 10 as myvalue" version=901 withdbname=false tagvalue="" measurement="whatever" [[inputs.postgresql_extensible.query]] sqlquery="select 'ten' as myvalue" version=901 withdbname=false tagvalue="" measurement="stringy" The output looks like this: * Plugin: postgresql_extensible, Collection 1 > something,db=postgres,host=sandbox.int.kcilink.com,server=host\=yertle\ user\=vivek\ dbname\=postgres myvalue="10.0" 1479323546000000000 > whatever,db=postgres,host=sandbox.int.kcilink.com,server=host\=yertle\ user\=vivek\ dbname\=postgres myvalue=10i 1479323546000000000 > stringy,db=postgres,host=sandbox.int.kcilink.com,server=host\=yertle\ user\=vivek\ dbname\=postgres myvalue="ten" 1479323546000000000 It seems that a feature request is in order to detect the type float as well and not double quote those values. The documentation for this module seems also to be wrong. The first hunk looks copied from the other postgresql plugin, and implies that you specify a setting called databases but that does nothing obvious. You really have to connect to the DB you want in the address string. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/145ee579-dc68-4aca-bad8-45a9a4eceb84%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
