Re: Inserting a tab character

From: Matthew Horoschun <mhoroschun(at)canprint(dot)com(dot)au>
To: "Luke Pascoe" <luke(dot)p(at)kmg(dot)co(dot)nz>
Cc: "Postgres Sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Inserting a tab character
Date: 2003-02-05 03:54:26
Message-ID: 85156C77-38BD-11D7-B773-000393B3A702@canprint.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Luke.

On Wednesday, February 5, 2003, at 02:39 PM, Luke Pascoe 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'?

insert into test values( '\t' );

appears to work...

Matt.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2003-02-05 07:59:14 Re: Inserting a tab character
Previous Message Luke Pascoe 2003-02-05 03:39:09 Inserting a tab character