Thread: field delimiter...

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 ?"


Thanks for your attention, please reply directly to me too, because I am
not on this list yet...


--

Regards...

Gianmarco
"Unix expert since yesterday"

http://www.giovannelli.it

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@cys.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-------