[GENERAL] Issue with COPY command

2014-08-27 Thread swaroop
In need of some help - The use case is to insert current time in UTC for a timestamp column using COPY command . It works fine if i just have now() in csv file input. But if i add now() at time zone 'utc' it gives the error as ERROR: invalid input syntax for type timestamp: "now() at time zone

Re: [GENERAL] Issue with COPY command

2014-08-27 Thread David G Johnston
swaroop wrote > In need of some help - The use case is to insert current time in UTC for a > timestamp column > using COPY command . It works fine if i just have now() in csv file input. > But if i add > now() at time zone 'utc' it gives the error as > ERROR: invalid input syntax for type timest