Re: using tab delimiter for csv format import - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: using tab delimiter for csv format import
Date
Msg-id 1361699251.2245.12.camel@localhost.localdomain
Whole thread Raw
In response to using tab delimiter for csv format import  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: using tab delimiter for csv format import
List pgadmin-support
On Sun, 2013-01-13 at 11:08 -0800, Jeff Janes wrote:
> I have a tab-delimited text file I want to import into a table.
> However, I do not want \t translated to tab characters, etc., which is
> what the "text" format does.  My file does not contain any special
> characters in need of escaping, and \ always just represents itself.
> 
> So instead I want to use the "csv" format and specify the tab as the
> delimiter (on the "misc. options" tab).  But, tab does not appear in
> the drop down list, and since typing tab changes the focus, a literal
> tab cannot by typed into this field.  I could get around this by
> typing a tab into WordPad, then copying and pasting it into the
> delimiter field.  But it would much nicer if the tab character was
> present in the delimiter drop down list (visibly represented by, say,
> "<tab>").
> 

I wonder how this could work through a COPY command. Did you try?
because the import tool is a simple wrapper around the COPY command.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com




pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: copy fragment from table data view
Next
From: Dave Page
Date:
Subject: Re: pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18