- Code: Select all
SQL command= /Library/PostgreSQL/bin/psql indigo_history postgres -c "SELECT id, to_char(ts,'YYYY-mm-dd-HH24:MI:ss'),value from variable_history_94014379 order by ID LIMIT 100 OFFSET (SELECT COUNT(*) FROM variable_history_94014379)-100;"