Issue with COPY command

From: swaroop <swaroop(dot)belur(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Issue with COPY command
Date: 2014-08-27 11:32:41
Message-ID: 1409139161217-5816527.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 'utc'"

I need to enforce UTC somehow to current time. Any pointers here pls ?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issue-with-COPY-command-tp5816527.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Piotr Gasidło 2014-08-27 12:19:23 Re: SELECT 'NOW()' - OK, SELECT 'CLOCK_TIMESTAMP()' - ERROR
Previous Message Ramesh T 2014-08-27 09:52:18 Deletion