kw123 wrote:... In the menu input type command-v to enter a tab character. ...
Isn't that just a Paste command? Not quite understanding what you mean
kw123 wrote:... In the menu input type command-v to enter a tab character. ...
2785$ 2015-09-13 06:19:14.176493$ $ 23.1$ 23.1 °C
id | ts | onoffstate | sensor value | sensorvalue_ui
------+----------------------------+------------+-------------+----------------
2736 | 2015-09-09 13:04:42.304044 | | 23.9 | 23.9 °C
/Library/PostgreSQL/bin/psql indigo_history postgres -A -F '; ' -c "SELECT id, to_char(ts,'YYYY-mm-dd-HH24:MI:ss'),value from variable_history_1040551329 ;"
kw123 wrote:YES!!!! how did you create that??
kw123 wrote:That would resolve the problem I thinkWe could add an order by id ...l
sqlCommandText+= " order by ID "
Users browsing this forum: No registered users and 0 guests