From: | "Anton Stckl" <tony(at)cys(dot)de> |
---|---|
To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
Cc: | pgsql-general(at)postgreSQL(dot)org, gmarco(at)giovannelli(dot)it |
Subject: | Re: [GENERAL] field delimiter... |
Date: | 1998-05-18 08:07:20 |
Message-ID: | 355FEC38.A886615F@cys.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The Hermit Hacker wrote:
>
> Hello to everyone, I am using FreeBSD 3.0-current, Postgres-6.3.2 and
> heitml-1.2.3 for doing my degree at university on a research work...
>
> Now I have to use some fields in a table that can contain the ' which is
> very common in italian language ...
>
> Is there a way of escape this one so I can put fields like :
>
> "Di che colore e' l'albero ?"
You'll have to use two single quotes like:
insert into table values ('Di che colore e'' l''albero ?');
-Tony
--
----------C-Y-B-E-R-S-O-L-U-T-I-O-N-S----------------
Anton Stöckl mailto:tony(at)cys(dot)de
CyberSolutions GmbH http://www.cys.de
Frankfurter Ring 193A Phone +49 89 32369223
80807 Muenchen Fax +49 89 32369220
------W-E----M-A-K-E----I-T----P-O-S-S-I-B-L-E-------
From | Date | Subject | |
---|---|---|---|
Next Message | Ferruccio Zamuner | 1998-05-18 14:05:08 | subscribe |
Previous Message | Yogesh Bhanu | 1998-05-18 03:49:46 | dbengine problems |