Re: Question about copy from with timestamp format

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Murali M <manips2002(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about copy from with timestamp format
Date: 2015-07-29 23:47:04
Message-ID: 55B965F8.8090700@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sherrylyn Branchaw 2015-07-30 00:27:07 Re: Question about copy from with timestamp format
Previous Message Tom Lane 2015-07-29 23:30:40 Re: instr detail