Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about copy from with timestamp format - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Question about copy from with timestamp format
Date
Msg-id 55B965F8.8090700@aklaver.com
Whole thread Raw
In response to Re: Question about copy from with timestamp format  (Murali M <manips2002@gmail.com>)
Responses Re: Question about copy from with timestamp format  (Sherrylyn Branchaw <sbranchaw@gmail.com>)
List pgsql-general
Tree view 
On 07/29/2015 03:55 PM, Murali M wrote:
> How do I specify that when I use copy from? this is what I am trying
> right now..
> copy myTable (myTimeCol, col2) from myFile delimiter as '\t'
>
> I am not sure how to specify the time format..

My previous post would have been more useful if I had added that the
temporary/staging table should have the 'timestamp' field set to
varchar/text so you could get the data in.

>
> thanks, murali.
>
>

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: instr detail
Next
From: Sherrylyn Branchaw
Date:
Subject: Re: Question about copy from with timestamp format