Message-ID: <46898000.7030601@autoledgers.com.au>
Date: Tue, 03 Jul 2007 06:45:20 +0800
From: Paul Lambert <paul.lambert@autoledgers.com.au>
User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Using escape strings in an insert statement.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm having a little glitch in using escape strings within strings.

The following will best explain my issue:

tester=# create table testing (test_text text);
CREATE TABLE

tester=# insert into testing (test_text) values ('abc\\123');
WARNING:  nonstandard use of \\ in a string literal
LINE 1: insert into testing (test_text) values ('abc\\123');
                                                 ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
INSERT 0 1

^^^ This works, but I still get an error/warning telling me to use E'\\' 
  - which I do:

tester=# insert into testing (test_text) values ('abcE'\\'123');
Invalid command \. Try \? for help.
tester(#

^^^ And this just doesn't work at all.


The help itself (ch 4.1.2.1) tells me to use double backslash "Thus, to 
include a backslash character, write two backslashes (\\). "

Which one is the correct syntax and how can I make it not return 
anything other than a successful insert?

Noob question, I know...

But TIA.

(Version is 8.2.3 on Weenblowz if that is of any relevance)

--
Paul Lambert
Database Administrator
AutoLedgers