Search Postgresql Archives

Re: Issue with COPY command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 timestamp: "now() at time zone
> 'utc'"
> 
> I need to enforce UTC somehow to current time. Any pointers here pls ?

Your timestamp column target should be with timezone and, if so, whatever
value 'now' resolves to will be converted to and stored in UTC
automatically.

Though typically you are better advised to simply not import a default
column and instead leave the table default expression to assign a value.

Also, you cannot use functions when importing via copy.  The 'now' in this
case is a special keyword interpreted by the timestamp input function and is
not actually a (direct) reference to the now() function provided by
PostgreSQL.

David J.





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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux