<operationsengineer1(at)yahoo(dot)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