- last edited on
I am trying to insert CSV records to Postgres database using nifi.
Sample csv file :
When nifi scenario runs,
it gives following error > Error column 'timenow' is of type timestamp without time zone but expression is of type character varying...
If I use normal `insert into conditions (timenow,location) values ('2019-10-21 15:13:11','colombo');` No errors values inserted to table. Do I have to change nifi configurations to add this to table?
`INSERT INTO public.conditions (timenow, location) VALUES ('2019-10-21 15:13:11','colombo')` I have used this with timescaledb terminal and it inserted the record.