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

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