X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 36BC44758DC
	for <pgsql-sql@postgresql.org>; Wed,  5 Feb 2003 02:59:14 -0500 (EST)
Received: from web80303.mail.yahoo.com (web80303.mail.yahoo.com
 [66.218.79.19])
	by postgresql.org (Postfix) with SMTP id 6FD82474E44
	for <pgsql-sql@postgresql.org>; Wed,  5 Feb 2003 02:59:13 -0500 (EST)
Message-ID: <20030205075914.79433.qmail@web80303.mail.yahoo.com>
Received: from [203.87.150.116] by web80303.mail.yahoo.com via HTTP;
	Tue, 04 Feb 2003 23:59:14 PST
Date: Tue, 4 Feb 2003 23:59:14 -0800 (PST)
From: Ludwig Lim <lud_nowhere_man@yahoo.com>
Subject: Re: Inserting a tab character
To: Luke Pascoe <luke.p@kmg.co.nz>
Cc: PostgreSQL Mailing List <pgsql-sql@postgresql.org>
In-Reply-To: <00d301c2ccc8$24c6f7a0$3200000a@K2>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/87
X-Sequence-Number: 11485


--- Luke Pascoe <luke.p@kmg.co.nz> wrote:
> I have a table which defines various possible file
> delimiters (CHAR(1) NOT
> NULL), for the moment it'll only contain comma and
> tab. Inserting a comma is
> easy, but inserting a tab is proving somewhat more
> difficult.
> 
> How do I do it in 'psql'?
> 

  --> Try using '\t' for tab.
Example :
   INSERT INTO table1(f1) values ('\t');

   I'm not sure if inserting a TAB character will
cause some side-effects for commands like COPY FROM /
TO since these commands use tab to delimit fields.

Hope that helps,

ludwig

Hope that helps,
ludwig.


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com