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

Please HELP: insert row ...

From: "Thu Huynh" <thu_huynh(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Please HELP: insert row ...
Date: 2000-10-14 04:15:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

Does anyone know how to insert/update data that contains single quote (') 
into a field? Data such as: John's house is in Dalas.

I know one can insert double quote by using single quotes as field 
delimiters.  But since I have to use single quotes as field delimiters, data 
cannot contain single quote.  Is there a way to change the field delimiter?

Thanks for your helps.


Get Your Private, Free E-mail from MSN Hotmail at

Share information about yourself, create your own public profile at


pgsql-novice by date

Next:From: John McKownDate: 2000-10-14 13:21:05
Subject: Re: Please HELP: insert row ...
Previous:From: Gord TomlinDate: 2000-10-13 16:39:29
Subject: RE: Importing Data into Postgresql from MS Access

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