|
Home > Archive > PostgreSQL Newbies > May 2005 > Escaped Characters (Quotes, etc...)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Escaped Characters (Quotes, etc...)
|
|
| operationsengineer1@yahoo.com 2005-05-26, 8:24 pm |
| hi all,
when i run a pgadmin3 query and select * from a table,
shouldn't the " mark appear like this : \" ?
right now it is appearing as it is entered. i'm using
adodb's qstr() function and i thought it added the
backslashes to the appropriate characters. however,
they don't show up in pgadmin3's query or when i print
the data to a web browser.
is something fishy going on here or am i missing something?
____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
| |
| Tom Lane 2005-05-26, 8:24 pm |
| < operationsengineer1@
yahoo.com> writes:
> when i run a pgadmin3 query and select * from a table,
> shouldn't the " mark appear like this : \" ?
No, what for?
You have to escape quotes that are going to be put into a string literal
in a SQL command string. But data coming out of the server is not in a
SQL command string and so it doesn't need that layer of quoting.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
|
|