Automatic Addslashes

From: "Enrico Comini" <algobit(at)algobit(dot)com>
To: "ML-Postrges-general" <Pgsql-General(at)Postgresql(dot)org>
Subject: Automatic Addslashes
Date: 2000-11-24 12:29:41
Message-ID: NCBBIOBMPJJBPJICNDLLAEAIEFAA.algobit@algobit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I do

copy tmp from '/home/algobit/product.txt

tmp ia a table with one record (line varchar(255))

in product.txt I have many line as:

2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true"

Then with "select * from tmp" the result is exactly like in the original
file

2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2
anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true"

But when i fetch in a variable the rercords (with php) i READ in the
variable

2;\"100\";\"Parmigiano Reggiano\";\"Parmigiano Reggiano stagionato 2
anni\";4;\"parmigiano4.jpg\";2;\"Fette 1 Kg\";0.18;1;1.00;\"true\"

the question is : The SLASH are effectively in the record ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2000-11-24 12:42:16 Re: Automatic Addslashes
Previous Message Jarmo Paavilainen 2000-11-24 11:44:47 SV: Table whose name has Capital letters