| From: | Sharon Chow <sharon(at)regaltronic(dot)com> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | insert statment |
| Date: | 1999-08-30 09:39:03 |
| Message-ID: | 37CA5137.35FF3ABC@regaltronic.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all!
I have a insert statement and I found problem with it!
The statement is:
Insert into product values('p001' , 'ASS'Y' , 'o')
The second field of the table is ASS'Y so the compiler found it is
error!
I can not change the data but wnat to change the quota ' to ~.
so the insert statement should be :
insert into product values(~p001~ , ~ASS'Y~ , ~o~ )
I can not find the seting function for this environment change!
How can I change it???
Thank You in advance!
sharon
Sharon Chow
???
Regaltronic
MIS
<sharon@
| Attachment | Content-Type | Size |
|---|---|---|
| sharon.vcf | text/x-vcard | 164 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregoire Thomas | 1999-08-30 09:56:01 | Re: [GENERAL] insert statment |
| Previous Message | Dirk Lutzebaeck | 1999-08-30 08:14:32 | Re: [GENERAL] OID vs SERIAL |