X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 71DCA4758F1
	for <pgsql-sql@postgresql.org>; Tue, 22 Apr 2003 22:35:03 -0400 (EDT)
Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57])
	by postgresql.org (Postfix) with ESMTP id B7417474E42
	for <pgsql-sql@postgresql.org>; Tue, 22 Apr 2003 22:35:01 -0400 (EDT)
Received: from jac (bri-ts3-2600-100.tpgi.com.au [203.219.26.100])
	by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id h3N2YrM20528
	for <pgsql-sql@postgresql.org>; Wed, 23 Apr 2003 12:34:57 +1000
Message-ID: <003301c30940$ed632300$1400a8c0@jac>
From: "jack" <datactrl@tpg.com.au>
To: <pgsql-sql@postgresql.org>
Subject: how to put an special code in a string
Date: Wed, 23 Apr 2003 12:33:07 +1000
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-Spam-Status: No, hits=-1.6 required=5.0
	tests=BAYES_30
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/319
X-Sequence-Number: 13020

Hi all,

With pg/Sql, how do I put an special code in a string? Such as

''abc'' || <tab>||''xxx''||<cr/lf>

How do I specify a tab or cr/lf code? Thank you

Jack