Re: Escaped Characters (Quotes, etc...) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Escaped Characters (Quotes, etc...)
Date
Msg-id 8787.1117144364@sss.pgh.pa.us
Whole thread Raw
In response to Escaped Characters (Quotes, etc...)  (<operationsengineer1@yahoo.com>)
List pgsql-novice
<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

pgsql-novice by date:

Previous
From: "Sugrue, Sean"
Date:
Subject: Explain
Next
From: "David Sadler"
Date:
Subject: Re: ERROR: relation "default_cols" does not exist