using tab delimiter for csv format import

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: using tab delimiter for csv format import
Date: 2013-01-13 19:08:28
Message-ID: CAMkU=1w5cTpCf=y_Uo+pLB8=MZAOJdom9mFk0AL0vbyg2Afecg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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>").

Cheers,

Jeff

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dan Halbert 2013-01-14 19:40:30 1.16.1: many operations cause display tree to collapse
Previous Message José Pedro 2013-01-11 15:40:19 Bug on pgAdmin III commit: Add a -V/--version CLI option?