| From: | Bruce Tong <zztong(at)laxmi(dot)ev(dot)net> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Character Constants |
| Date: | 1999-08-19 18:53:51 |
| Message-ID: | Pine.LNX.4.10.9908191441150.1749-100000@laxmi.ev.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I found in the documention where you can use \tab and from playing I see I
can use \n in a string and \ooo and use an octal value, but I've not found
a way to include a character based on a hex representation of its ascii
code...
\x03
\X03
\0x03
\0X03
...all failed in cases like this ...
INSERT INTO mytable ( mystring ) VALUES ( 'This is a \x03 character.' );
... so what's the trick? I hope I'm not missing something obvious.
--
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dalphin | 1999-08-19 20:46:05 | Error during 'vacuum analyze' |
| Previous Message | Chul-Su Park | 1999-08-19 16:33:42 | [Q] 6.3.2->6.5.1, pg_dump with large object & backend cache... |