Search Postgresql Archives

Re: selective export for subsequent import (COPY)

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

 



Hi Tom,

It appears to me that the documentation suggests that:   -P fieldsep='\t'  
should work, but I don't think it does.


Tom Lane-2 wrote:
> 
> chrisj <chrisj.wood@xxxxxxxxxxxx> writes:
>> This helped a lot, but ideally I want a tab field delimiter and -F '\t'
>> does
>> not seem to work, any ideas??
> 
> I don't think there's any provision for backslash-notation in that
> switch; you'd need to type an actual tab character there.  Depending on
> what shell you use, that might be a bit difficult on an interactive
> shell command line, but it should be simple enough to insert one in a
> script file.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 
> 

-- 
View this message in context: http://www.nabble.com/selective-export-for-subsequent-import-%28COPY%29-tf3604927.html#a10102249
Sent from the PostgreSQL - general mailing list archive at Nabble.com.



[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