I have a with meterid,meterreading,reader and date read.I wish to store this data using Postgis database. I used this code via postgresql to create the table CREATE TABLE MeterRdg(meterid VARCHAR(5) NOT NULL PRIMARY KEY, reading integer,reader VARCHAR(15),DateRead date).
I then tried to...