Hi,

i got a following problem,
the sql query is:

INSERT INTO
struktur(pordnr,bed,satznr,katalognr,vgl,anz,art,l ogik,funktionen,xkoord,ykoord,verknop)
('8139','G','113','-2','M','1','A',')!','gewicht:UB;sql:me.labnr;setze _erw:LAB.pnote='',
LAB.bonus=''','9','1','o'),
('8139','G','104','-2','G','1','A','/','gewicht:UB;sql:me.labnr;setze_erw:LAB.pstatus=' EN',
LAB.bonus='', LAB.pnote='500'','1','2','')


the problem is here in this part:
'gewicht:UB;sql:me.labnr;setze_erw:LAB.pstatus='EN ', LAB.bonus=''

this is one string which is supposed to belong to funktionen.

the parser gets crazy at this point
'gewicht:UB;sql:me.labnr;setze_erw:LAB.pstatus='E

Now my question is there some special command which allows me to insert
a string which contains one or more apostrophe ?

N.G., 25.03.2009 10:02:

In Postgres it's like in any other (standard compliant) database, simply put two single quotes in there:

INSERT INTO my_table
(some_data)
VALUES ('With '' single quote');

In your case this would be:

'gewicht:UB;sql:me.labnr;setze_erw:LAB.pnote='''', LAB.bonus='''' '

(I added a space before the "closing" quote to make clear where the actual value ends)

Thomas

Thomas Kellerer schrieb:

you were right i just got to less '


Nico