Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] how to change delimiter single-quote ?

From: Simon Drabble <simond(at)foxlink(dot)net>
To: abdelkrim <haj(at)idianet(dot)net>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] how to change delimiter single-quote ?
Date: 1999-06-29 18:41:31
Message-ID: Pine.LNX.3.96.990629143906.12766A-100000@dragon (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, 29 Jun 1999, abdelkrim wrote:

> Hello
> 
> I'have some problems with single-quote,
> if i insert some text with single-quote ( ' ) error occured !!!
> thanks
> 
> 
> 

The common way to achieve this is to double up the quotes:

INSERT INTO table (column) VALUES ('Some ''quoted'' text');


Simon.


-- 
 "Half-dead cat found in box -- Animal Rights group seeks Austrian scientist"
   
   Simon Drabble                      Somewhere in cyberspace
   simond(at)foxlink(dot)net


In response to

Responses

pgsql-general by date

Next:From: abdelkrimDate: 1999-06-29 18:45:40
Subject: Re: [GENERAL] how to change delimiter single-quote ?
Previous:From: inlinDate: 1999-06-29 18:19:43
Subject: About the restore from V1.09 to V6.3.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group