X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F2E39475A1E for ; Tue, 4 Feb 2003 22:38:51 -0500 (EST) Received: from cook.itsd.co.nz (visp5-179.visp.co.nz [210.54.179.5]) by postgresql.org (Postfix) with ESMTP id E694547595A for ; Tue, 4 Feb 2003 22:38:49 -0500 (EST) Received: from K2 (k2.md5summer.org [10.0.0.50]) by cook.itsd.co.nz (8.12.3/8.12.3/Debian -4) with SMTP id h153ceKS029337 for ; Wed, 5 Feb 2003 16:38:42 +1300 Message-ID: <00d301c2ccc8$24c6f7a0$3200000a@K2> From: "Luke Pascoe" To: "Postgres Sql" Subject: Inserting a tab character Date: Wed, 5 Feb 2003 16:39:09 +1300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/85 X-Sequence-Number: 11483 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'? Luke Pascoe.