Re: Deep quotation - Mailing list pgsql-novice

From Tom Lane
Subject Re: Deep quotation
Date
Msg-id 28789.1032102475@sss.pgh.pa.us
Whole thread Raw
In response to Deep quotation  (Casey Allen Shobe <cshobe@secureworks.net>)
List pgsql-novice
Casey Allen Shobe <cshobe@secureworks.net> writes:
> I can't seem to get the quoting around "Customers" right in the statement
> below.  In db2, I can use \' to escape the quote, and it will insert into the
> database properly.

That works in PG too, or you can use the spec-approved method of
doubling the quote.  See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-syntax.html#SQL-SYNTAX-CONSTANTS

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner
Next
From: Casey Allen Shobe
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner